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.

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.

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe to comments feature has been disabled. To receive notification of latest comments posted, subscribe to My Digital Life Comments RSS feed or register to receive new comments in daily email digest.
« ORA-01502 Oracle Index in Unusable State
VuGo Portable Multimedia Center – On-the-go Video for Tweens »

Custom Search

New Articles

Incoming Search Terms for the Article

imp-00013 - IMP-00013: only a DBA can import a file exported by another DBA - only a dba can import a file exported by another dba - imp-00013 oracle - IMP-00013: - imp 00013 - Oracle IMP-00013 - imp-00013 only a dba can import a file exported by another dba - oracle imp dba - oracle grant import - "IMP-00013: only a DBA can import a file exported by another DBA" - oracle grant import privilege - oracle imp - oracle imp IMP-00013 - oracle import dump as admin - grant import oracle - error ora-01502 while import - imp oracle - import oracle user grant - IMP oracle dba job opening - import error grant to role oracle - import 00013 - IMP-00013: only a DBA can import a file exported by another DBA - 10g impdp grant - grant errors import oracle - grant imp to user? - import .dmp oracle "imp-00013" - oracle imp error 30036 - oracle error 31623 impdp - can we Import of dmp file from 32-bit to 64-bit machine - IMP-00013: only a DBA can import a file exported by another DB - imp00013 - IMP-00013: only a DBA can import a file exported by another DBA - ora-00013 solution - oracle imp touser - oracle dump user not exist also is existing - ora-00013 - errors while doing import in oracle - while importing dump file in oracle getting the error only a dba can import a file exported by another dba - all - imp 00013 only a dba can import a file exported by another dba - imp-00013? - "only a DBA can import a file exported by another DBA" - oracle import errors - grant privilage to import in oracle - grant import to user oracle - how to imp oracle database dump from anothe user - IMP-00013: only a dba can import a file exported by - oracle import IMP-00013 - oracle imp nCLOB problem -