import does not work
Posted on 2009-04-13
I created a scehma/user 'xyz_user' using command
create user xyz_user identified by password;
and granted following privileges to it like
grant resource, exp_full_database, imp_full_database,create session to xyz_user;
I imported a schema dump file 'Database_Dumpfile_1'supplied by client with data, structure into xyz_user using command
imp xyz_user/password full=y file=Database_Dumpfile_1.dmp
Later I made some changes to table structure, data.
Now when I tried to export latest updated schema back to dump file 'Database_Dumpfile_2' to deliver back to the client using usual old command
exp xyz_user/password indexes=n full=y file=Database_Dumpfile_2.dmp
It is exporting entire database( including all schemas) instead of just required single 'xyz_user' schema .
so i introduced
to export only the specific schema.
Now at client end when we try to import this dump file
imp client_user/password full=y file=Database_Dumpfile_2.dmp
giving error message like 'cannot open the dump file'.
Do i need to introduce
owner='(xyz_user)' in the import statement as well? when I introduced it like
imp client_user/password full=y owner='(xyz_user)' file=Database_Dumpfile_2.dmp it did not like it, says check help section for correct options etc.
Earlier i used use following privilege command
GRANT all privilege TO xyz_user WITH ADMIN OPTION
which never gave issues like this and used to export only single schema instead of entire database with all schema
How can I import this dump file. What is the command i should use for this. Any sample code, ideas, resources, links highly appreciated. Thanks in advance.