how to grant privelege to user on importing dump file
Posted on 2009-03-30
I have created a user/schema say XYZ in oracle 10g. I gave the privilege to the user as
grant resource to XYZ ;
I gave ran all the DDL scripts to generate Table, Sequence, Trigger etc structure.
Then I am importing the dump file(say abc.dmp) into the schema using the command
imp XYZ/password full=y file=abc.dmp ignore=y
When I do that getting error saying
ORA-01031: insufficient privileges
How can i get rid of this error. Is there is a way I can give import operation privilege to this particular user XYZ. Please advise. Any links , resources, ideas highly appreciated. Thanks in advance.