Home » RDBMS Server » Server Utilities » ORA-39127: (Solaris 10)
ORA-39127: [message #447000] Thu, 11 March 2010 07:20 Go to next message
Messages: 45
Registered: November 2005
Location: India

While I'm trying to full DB EXPORT using EXPDP on Oracle Database 11g Release, getting two errors:

ORA-39127: unexpected error from call to export_string =WMSYS.LT_EXPORT_PKG.system_info_exp(0,dynconnect,'',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,

------------------------------ ----------

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?


Re: ORA-39127: [message #447008 is a reply to message #447000] Thu, 11 March 2010 08:12 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: Import only sequences using data pump
Next Topic: Copy data from one DB to another
Goto Forum:

Current Time: Wed Oct 26 09:08:48 CDT 2016

Total time taken to generate the page: 0.10069 seconds