欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

expdp遇到ORA-39126错误

程序员文章站 2022-05-13 15:20:08
...

Oracle数据库是11.2.0.4的RAC,在其中一个节点上面进行expdp,报以下错误:Estimate in progress using BLOCKS method...ORA-3912

问题描述:
Oracle数据库是11.2.0.4的RAC,,在其中一个节点上面进行expdp,报以下错误:

Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-00904: : invalid identifier

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 9710

----- PL/SQL Call Stack -----
object line object
handle number name
0x104ec64fb0 21979 package body SYS.KUPW$WORKER
0x104ec64fb0 9742 package body SYS.KUPW$WORKER
0x104ec64fb0 11838 package body SYS.KUPW$WORKER
0x104ec64fb0 14674 package body SYS.KUPW$WORKER
0x104ec64fb0 2734 package body SYS.KUPW$WORKER
0x104ec64fb0 10422 package body SYS.KUPW$WORKER
0x104ec64fb0 1824 package body SYS.KUPW$WORKER
0x10373876f8 2 anonymous block

Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS []
ORA-00904: : invalid identifier

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 9710

----- PL/SQL Call Stack -----
object line object
handle number name
0x104ec64fb0 21979 package body SYS.KUPW$WORKER
0x104ec64fb0 9742 package body SYS.KUPW$WORKER
0x104ec64fb0 11838 package body SYS.KUPW$WORKER
0x104ec64fb0 14674 package body SYS.KUPW$WORKER
0x104ec64fb0 2734 package body SYS.KUPW$WORKER
0x104ec64fb0 10422 package body SYS.KUPW$WORKER
0x104ec64fb0 1824 package body SYS.KUPW$WORKER
0x10373876f8 2 anonymous block

解决方法:
grant execute on DBMS_METADATA to public;

执行之后再次进行导出就没再报错了。

----------------------------华丽丽的分割线----------------------------

Oracle导入导出expdp IMPDP详解

Oracle 10g expdp导出报错ORA-4031的解决方法

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626

Oracle中利用expdp/impdp备份数据库的使用说明

Oracle备份还原(expdp/impdp)