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.