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 successNow 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 unsuccessfullyI 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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments