expdp遇到ORA-39126錯誤

expdp遇到ORA-39126錯誤

問題描述：
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）