6

When I try to import an oracle dump. Following the error displayed,

Export file created by EXPORT:V10.02.01 via direct path

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

IMP-00000: Import terminated unsuccessfully

I just wondering If the non-dba user exports a dump file. Can non-dba user import the dump file?

Hasan Fathi
  • 5,610
  • 4
  • 42
  • 60
nayakam
  • 4,149
  • 7
  • 42
  • 62

2 Answers2

6

Yes , non-dba user can import/export files from his/her schema without any problem. But if it wants to import/export files to/from other schema it must have been granted IMP_FULL_DATABASE/EXP_FULL_DATABASE roles .

BUT, here I can see that you are trying to import dump file, which was exported by direct path. In this situation just DBA can import directly exported file.

You can temporarily grant DBA role to this user , import file and then revoke this privilege.

SQL> conn / as sysdba
Connected.
SQL> grant IMP_FULL_DATABASE to test;

I hope it was helpfull for you :)

prashant thakre
  • 5,061
  • 3
  • 26
  • 39
kupa
  • 1,861
  • 5
  • 25
  • 41
2

Yes, it works fine to export and import under a non-DBA user. You'll still need a privileged login to create the destination user if it doesn't already exist.

JOTN
  • 6,120
  • 2
  • 26
  • 31