IMP-00013 only DBA can import files exported by other DBAs
IMP-00013 only DBA can import files exported by other DBAs
-- Instance demo
--- System user Export
C: \ Users \ ZML> exp system/zml file = 'd: \ zml. dmp 'Log = 'd: \ zml. log' tables = (zml)
Export: Release 11.2.0.1.0-Production on Monday April 21 21:39:12 2014
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
The ZHS16GBK and AL16UTF16 NCHAR character sets have been exported.
To export the specified table, use the regular path...
.. Export table ZML export 0 rows
The export is successfully terminated without a warning.
C: \ Users \ ZML>
------ Scott user import -------------------
C: \ Users \ ZML> imp scott/zml file = 'd: \ zml. dmp 'Log = 'd: \ zml1.log' full = y
Import: Release 11.2.0.1.0-Production on Monday April 21 21:57:40 2014
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXPORT File Created by EXPORT: V11.02.00 in the normal path
IMP-00013: only DBA can import files exported by other DBAs.
IMP-00000: Import failed
C: \ Users \ ZML>
-------- Grant permissions to the scott user dba --------------------
SQL> grant dba to scott
2;
Authorization successful.
SQL>
------- Scott user import ---------------
C: \ Users \ ZML> imp scott/zml file = 'd: \ zml. dmp 'Log = 'd: \ zml1.log' full = y
Import: Release 11.2.0.1.0-Production on Monday April 21 22:04:39 2014
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
EXPORT File Created by EXPORT: V11.02.00 in the normal path
Warning these objects are exported by SYSTEM instead of the current user.
The ZHS16GBK Character Set and AL16UTF16 NCHAR character set have been imported.
. Importing the SYSTEM object to SCOTT
. Importing the SYSTEM object to SCOTT
.. Importing the table "ZML" to 0 rows
Import terminated successfully. No warning is displayed.
C: \ Users \ ZML>
,