Skip to content
Home » Oracle » How to Resolve IMP-00013: only a DBA can import a file exported by another DBA

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

IMP-00013

IMP-00013 was reported by a normal user who want to import some data from other database.

C:\Windows\system32>imp hr/password@orclpdb file=D:\dumps\hr.dmp ...
...
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully.

IMP-00013 means that some privileges are missing from the import user, so import failed to proceed and terminated unexpectedly.

Solution

According to the explanation of import error code from IMP-00000 to IMP-00403, you should ask for DBA to do it.

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


Cause: The privileges needed to Import an export file generated by a database administrator do not exist. Only a database administrator can import such files.


Action: Ask the database administrator to do the import.

Actually, you don't need DBA role to do it, just ask for DBA to grant a simple role, IMP_FULL_DATABASE to you.

SQL> grant imp_full_database to hr;

Grant succeeded.

IMP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database imports using the Import utility.

As for DBA role, it's too much for users who just only want to import data, IMP_FULL_DATABASE is pretty enough to solve IMP-00013.

Leave a Reply

Your email address will not be published. Required fields are marked *