Privilege required to do Export and Import
700386Jul 14 2009 — edited Jul 14 2009Hi All,
I have question regarding import and export done by a ordinary DB user.
I have granted IMP_FULL_DATABASE and EXP_FULL_DATABASE role to a user.
I am able to take export and to import using that.
I want to know is any other roles or privillege we can use to perform import and export tasks.
The reason behind this question is, after granting the above mentioned privillege to a user i have taken the export and i tried to import the dump into another database in onsite location using a ordinary user. i am getting the following error saying that
IMP-00013 only a DBA can import a file exported by another DBA
I have done the import after granting DBA privillege to that particular user.
Kindly help me in this.
Thanks in advance.
Regards,
Aruna