Can oracle import be used as a non-dba user?

Question

When I try to import an oracle dump. The following error appears:

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

IMP-00013: only the database administrator can import a file exported by another database administrator

IMP-00000: Import Failed

I'm just wondering if a non-dba user is exporting a dump file. Can a non-dba user import a dump file?

+3

nayakam Mar 09 '11 at 4:03

2 answers

, , . , .

+2

JOTN 09 . '11 4:15

kupa · Accepted Answer · 2011-03-09T11:53:34+0000

, -dba / . / / , IMP_FULL_DATABASE/EXP_FULL_DATABASE.

, , , . DBA .

, .

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

, :)