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:
- Import the export file by using a user with database administrator privileges, with FROMUSER and TOUSER parameters.
- 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.
- Re-export the dump file from a non-DBA user account.
Share and contribute or get technical support and help at My Digital Life Forums.
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-00942 Table or View Does Not Exist Oracle Error
- ORA-02449 Oracle Drop Table Error
- Oracle ORA-01658 Unable to Create INITIAL Extent for Segment in Tablespace Error
- Oracle JDeveloper Reviews
- ORA-01502 Oracle Index in Unusable State
































