Home » RDBMS Server » Performance Tuning » Invalid Object in sys schema
Invalid Object in sys schema [message #65947] Fri, 04 February 2005 10:39 Go to next message
Sarah
Messages: 15
Registered: June 1999
Junior Member
Hi, I have following invalid objects in one of my database. I tried to recompile them but no good result. Do I need to re-run catpatch? If not, how do I make these invalid objects valid?

-------
SYS DBA_LOGSTDBY_LOG VIEW
SYS DBA_LOGSTDBY_PROGRESS VIEW
SYS DBMS_CAPTURE_PROCESS PACKAGE BODY
SYS DBMS_INTERNAL_LOGSTDBY PACKAGE BODY
SYS DBMS_LOGMNR_D PACKAGE BODY
SYS DBMS_LOGMNR_FFVTOLOGMNRT PROCEDURE
SYS DBMS_LOGMNR_OCTOLOGMNRT PROCEDURE
SYS DBMS_LOGMNR_SESSION PACKAGE BODY
SYS DBMS_LOGSTDBY PACKAGE BODY
SYS LOGMNR_DICT_CACHE PACKAGE BODY
SYS LOGMNR_GTLO3 PROCEDURE
SYS LOGMNR_KRVRDA_TEST_APPLY PROCEDURE
SYS LOGMNR_KRVRDLUID3 PROCEDURE
SYS LOGMNR_KRVRDREPDICT3 PROCEDURE
-------

Thanks,
Sarah
Re: Invalid Object in sys schema [message #109306 is a reply to message #65947] Wed, 23 February 2005 12:35 Go to previous message
Mack Sundar
Messages: 20
Registered: July 2002
Junior Member
It is usually a good idea to ensure that all objects being referenced by these invalid objects are valid. For instance, if a procedure references a column of a table that is no longer available in the table, the procedure will be invalid.

However, since these are SYS objects and I presume you have not created any tables using the SYS, check your Views.
Previous Topic: Diff Execution Plan for Same Query?Pl:help
Next Topic: materialized view
Goto Forum:
  


Current Time: Sun Sep 27 22:28:31 CDT 2020