imp-00013

来源：互联网发布：淘宝申请小二介入快吗编辑：程序博客网时间：2024/06/06 06:01

IMP-00013: only a DBA can import a file exported by another DBA
IMP-00000: Import terminated unsuccessfully

此时无需赋予DBA权限，赋予imp_full_database权限即可。

SQL> grant imp_full_database to test;

imp userid=test/oracle_4U@orcl buffer=104857600 recordlength=65535 file=exp_worker.dmp log=imp_worker.log FEEDBACK=100 fromuser=test tables=worker
Import: Release 11.2.0.4.0 - Production on Fri Sep 9 02:36:15 2016
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 direct path
Warning: the objects were exported by SYSTEM, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
. importing SYSTEM's objects into TEST
. importing TEST's objects into TEST
. . importing table "WORKER"
2 rows imported
Import terminated successfully without warnings.

0 0