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

1
2
3
4
5
6
7
8
9
10
[oracle@aud oradata]$ imp aud/xxxx file=/u01/app/oracle/oradata/audit_log.dmp tables=audit_log
Import: Release 11.2.0.4.0 - Production on Wed Jun 3 10:54:17 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.02.00 via conventional path
IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

1
2
$ imp 'aud/xxxx as sysdba' =/u01/app/oracle/oradata/audit_log.dmp tables=audit_log fromuser=sys touser=aud ignore=y log=imp.log

1
2
SQL> grant imp_full_database to aud;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
[oracle@aud oradata]$ imp nsfcaud/nsfcaud_rac11g file=/u01/app/oracle/oradata/audit_log.dmp tables=audit_log
Import: Release 11.2.0.4.0 - Production on Wed Jun 3 11:05:45 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V11.02.00 via conventional path
Warning: the objects were exported by SYS, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
export client uses AL32UTF8 character set (possible charset conversion)
. importing SYS's objects into AUD
. importing SYS's objects into AUD
. . importing table
"AUDIT_LOG"
22491788 rows imported
Import terminated successfully without warnings.

1
2
SQL> revoke exp_full_database,imp_full_database from XXXX;