I am trying to export all the tables from Scott schema and I created a
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
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??
Just change the files with the following contents
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
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
Run the export with the following command
Similarly for importing data u can use the following paramter file and comand
Run the following command with the import command
In case of any help please be free to ask me at email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i
Click Here to Expand Forum to Full Width