Generally encountered IMP-00013: Only DBAs can import files exported by other DBAs
There are usually two workarounds:
1. Grant DBA authority to the user performing the export (grant before derivative, revoke DBA Authority after import)
2. Re-export data with non-DBA users (if the DMP file is larger, it takes a long time)
If you have DBA authority, you can easily avoid these two problems.
3. Use DBA authority with Fromuser, Touser parameters for import
such as: Imp report/myoracle file=1.dmp fromuser=reporttouser=scott ignore=yes
E:/>imp Scott/tiger File=1.dmp
Import:release 11.2.0.1.0-production on Wednesday April 17:12:06
Copyright (c) 1982, the Oracle and/or its affil Iates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production
with the partitioning, OLAP, Data Minin G and Real Application testing options
Export files created by export:v11.02.00 through the regular path
IMP-00013: Only DBAs can import files exported by other DBAs
IMP-00000: Import not successfully terminated
E:/>imp report/report file=1.dmp fromuser=report touser=scott ignore=yes
Import:release 11.2.0.1.0-production on Wednesday April 20 17:28:54 2011
Copyright (c) 1982, the 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 files created by export:v11.02.00 through the regular path
Import is completed in ZHS16GBK character set and Al16utf16 NCHAR character set
Import server uses the Al32utf8 character set (possible character set conversions)
. Importing object from report to SCOTT
. . Importing table "CUSTOMERS" Imports 1 rows
The import was terminated successfully and no warning occurred.
Issue 2: Import user Scott is not a DBA, but everywhere the user system is a DBA. In this case, even if you join Fromuser, you must give Scot with DBA authority after the imp Scott/sakura fromuser=system Touser=scott file=c:\b.dmp
Today you encounter IMP-00013: only DBAs can import files exported by other DBAs, find solutions on the Web, and therefore reprint and annotate another case.