expdp遇到ORA-39126错误

2015-07-16 12:09:12 · 作者: · 浏览: 1

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;


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


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