Home » RDBMS Server » Server Utilities » ORA-39127: (Solaris 10)
ORA-39127: [message #447000] Thu, 11 March 2010 07:20 Go to next message
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 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: Sat Dec 10 17:02:00 CST 2016

Total time taken to generate the page: 0.13208 seconds