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.

Source: Internet
Author: User
Tags reserved

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.