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

• IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database
• Oracle Database Import Error 3113/3114
• Oracle EXP-00091 Error When Export Database
• Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error
• ORA-00942 Table or View Does Not Exist Oracle Error
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error
• Grant Read Write (Full Control) Permissions on Registry Keys (Fix Cannot Import and Access Denied Error in RegEdit)
• Oracle ORA-14074 Create or Add New Partition Fails Error
• ORA-25153 Temporary Tablespace is Empty Error in Oracle
• Oracle PL/SQL ORA-00947 Not Enough Values Error

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.