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

Error: During the import of the datapump backup getting the following error:

Export file created by EXPORT:V12.02.00 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

Cause: The user from which the IMPDP datapump is running needs to have dba or IMP_FULL_DATABASE privilege to import in another user.

Solution: Grant the IMP_FULL_DATABASE privilege to the user or run with the user that has the dba or IMP_FULL_DATABASE Privilege.

--To give the permission to the user:
grant IMP_FULL_DATABASE to username;
Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.