-
I am trying to export all the tables from Scott schema and I created a
Parameter file
FILE=scott.dmp
TABLES=(*)
ROWS=Y
COMPRESS=Y
feedback=10
I issued command C:\>exp scott/tiger parfile=abcd.dat
I got warning EXP-00011:Scott.* does not exist
Export terminated successfully with warnings.
I tried to do Import c:\>imp sys/sys parfile=scott.dat
My parameter file is
file=scott.dmp
fromuser=scott
touser=mery
tables=(*)
ignore=y
Import terminated successfully without warnings
Now when I connect as user mery and issued command
select * from tab;
I get no rows selected.
What is the problem over here??
Any Help..
Thanks
Rekha
-
Hi
Just change the files with the following contents
1) abcd.dat
file=scott.dmp
feedback=10
2) scott.dat
file=scott.dmp
fromuser=scott
touser=mery
ignore=y
Then Execute the export as follows
c:\> exp scott/tiger parfile=abcd.dat
By Default it will export all objects of the user to the dmp file by the name scott.dmp will be created
Then Execute the import as follows
c:\> imp sys/change_on_install parfile=scott.dat
I have used the password as change_on_install because that is the default password of sys which you might have allready changed.Before executing make sure the user mery has connect,resource privilege
Regards
Santosh
-
Hi rekha,
U cannot use * in tables parameter.In order to take the export of all the tables in SCOTT user schema use OWNER=SCOTT in ur parameter file .
The correct syntax of ur paramter file will look like this
e.g. a.txt
userid=scott
file=scott_exp.dmp
log=scott_exp.log
owner=scott
rows=y
indexes=y
consistent=y
Run the export with the following command
c:\>exp parfile=a.txt
Similarly for importing data u can use the following paramter file and comand
e.g. b.txt
userid=scott
file=scott_exp.dmp
log=scott_imp.log
fromuser=scott
touser=scott
rows=y
indexes=y
Run the following command with the import command
c:\>imp parfile=b.txt
In case of any help please be free to ask me at rohitsn@altavista.com
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|