暂无图片
手动建库之后,impdp导入有报错
我来答
分享
伤城
2021-04-08
手动建库之后,impdp导入有报错

impdp system/oracle directory=datadump dumpfile=20210408_%U.dmp

Import: Release 11.2.0.4.0 - Production on Thu Apr 8 13:24:52 2021

Copyright © 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

UDI-04067: operation generated ORACLE error 4067
ORA-04067: not executed, package body “SYS.DBMS_DATAPUMP” does not exist
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_DATAPUMP”
ORA-06512: at line 1

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
gelyon

可能是缺少DBMS_DATAPUMP系统包,建议先执行如下语句,查看下是否有无效的组件:

select comp_id, comp_name, version, status from dba_registry;
复制

如果存在无效组件,则使用utlrp重新编译数据库中的所有对象:

$ sqlplus "/as sysdba" SQL> @?/rdbms/admin/utlrp.sql
复制

另一个方法可以手动编译SYS.DBMS_DATAPUMP包:

$ sqlplus "/as sysdba" SQL> alter package SYS.DBMS_DATAPUMP compile body; SQL> select * from dba_errors where OWNER='SYS' and NAME='DBMS_DATAPUMP';
复制
暂无图片 评论
暂无图片 有用 0
打赏 0
你好我是李白

(1)查询dbms_datapump状态

SQL> SELECT owner, object_name, object_type, status
FROM   dba_objects
WHERE  object_name like '%DBMS_DATAPUMP%'
ORDER BY 1,2,3;

复制

(2)如果不存在,则创建

SQL>?/rdbms/admin/prvtdp.plb
SQL>?/rdbms/admin/utlrp.sql

复制
暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏