IMP-00013 Oracle Import Error

When trying to import an export dump file that has been exported by a DBA, the following error occurs:

IMP-00013: only a DBA can import a file exported by another DBA

The issue is because the privileges needed to import an export dump file generated by a database administrator do not exist. Only a database administrator can import a export file dumped by another database administrator.

There are several workarounds to solve the problems:

1. Import the export file by using a user with database administrator privileges, with FROMUSER and TOUSER parameters.
2. Grant the sufficient privileges (ie. database administrator) to the user. To do this, use the SQL*Plus and issue command “Grant DBA to db_user;”. This can be done temporarily by revoking the privileges after the import.
3. Re-export the dump file from a non-DBA user account.

Related Articles

• Oracle Database Import Error 3113/3114
• Oracle EXP-00091 Error When Export Database
• IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database
• Manual and Clean Uninstall Oracle for Windows
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error
• ORA-02449 Oracle Drop Table Error
• Oracle JDeveloper Reviews
• ORA-00942 Table or View Does Not Exist Oracle Error
• Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error
• Change Oracle Database User Password

This entry was posted on Saturday, January 28th, 2006 at 4:08 pm and is filed under Databases. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.