imp-00013

最新推荐文章于 2021-04-04 22:19:40 发布

逝鸿

最新推荐文章于 2021-04-04 22:19:40 发布

阅读量597

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/qq_21127313/article/details/52484706

本文介绍了解决Oracle数据库导入过程中遇到的IMP-00013错误的方法，指出无需赋予DBA权限，而是授予imp_full_database权限即可解决问题，并展示了具体的SQL授权语句及导入操作命令。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.