ORA-39127: [message #447000] |
Thu, 11 March 2010 07:20 |
AlinaC
Messages: 45 Registered: November 2005 Location: India
|
Member |
|
|
While I'm trying to full DB EXPORT using EXPDP on Oracle Database 11g Release 11.1.0.6.0, getting two errors:
ORA-39127: unexpected error from call to export_string =WMSYS.LT_EXPORT_PKG.system_info_exp(0,dynconnect,'11.01.00.00.00',newblock)
ORA-04063: package body "WMSYS.LT" has errors
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT"
ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 633
ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 658
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 5895
I think invalid object in WMSYS schema causing the problem,
OWNER INVALID
------------------------------ ----------
WMSYS 13
Should I recompile the invalid objects in wmsys schema, It's a production server , so what should be the right procedure to recompile , approximately how much time it can take?
Thanks,
Alina
|
|
|
Re: ORA-39127: [message #447008 is a reply to message #447000] |
Thu, 11 March 2010 08:12 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
It has to do with workspace manager.
Are you using it? Else disable it.
Have not checked with 11g, but it used to be owmuinst.plb that would uninstall.
Else, just ignore. These sought of messages are just warning.
|
|
|