ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.SCHEMA_INFO_EXP('REPOS',0,1,'11.02.00.00.00',newblock) ORA-04063: package body "WMSYS.LT_EXPORT_PKG" has errors ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT_EXPORT_PKG" ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_METADATA", line 9427Querying the dba_registry showed OWM (Oracle Workspace Manager) status invalid.
Execute on utl_file has been revoked from public for security and 1331906.1 says grant utl_file to wmsys but this did not resolve the issue.
Running (1263697.1)
dbms_registry.loading('OWM', 'Oracle Workspace Manager', 'VALIDATE_OWM', 'WMSYS');didn't help either.
Finally reinstall the OWM (731576.1)
$ORACLE_HOME/rdbms/admin/owminst.plband OWM status became VALID in the dba_registry and expdp continue without any errors.
Useful metalink notes
ORA-39705 When Removing Oracle Workspace Manager [ID 1263697.1]
Errors During Full DataPump Export (EXPDP) In 11gR2 [ID 1331906.1]
How do you manually install/deinstall Oracle Workspace Manager [ID 731576.1]
Related Posts
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.SCHEMA_INFO_EXP while Exporting
Dictionary Scripts