| Invalid Object in sys schema [message #65947] |
Fri, 04 February 2005 10:39  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
