Q
Problem solve Get help with specific problems with your technologies, process and projects.

"Only a DBA can import a file exported by another DBA" error

I'm getting these errors: "Export file created by EXPORT:V09.02.00 via direct path, IMP-00013: only a DBA can import a file exported by another DBA, IMP-00000: Import terminated unsuccessfully."

I have .dmp file in path /home/vikas on Linux. I want to import this in the Oracle database. To do this I have created a user by doing sqlplus@ system/manager
SQL>create user <user> identified by <passwd> 
default tablespace users temporary tablespace temp;

User Created

SQL>grant connect to <user>;

grant success
Now when I am trying to import file by giving the command:
SQL>imp <user>/<passwd> file=/home/vikas/<filename.dmp>;
It's giving me the error:
Export file created by EXPORT:V09.02.00 via direct path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully
I am using RedHat Linux EL3 and Oracle 9i.
As the error message says, only a user with the DBA role can import a file exported by a user who has the DBA role. Grant DBA to the user and then try the import again. If you do not need the DBA role, then revoke it after the import is done.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close