Hi:
This morning I found that in our production oracle 8173 db (on Solaris 2.8)
there were some invalid sys package bodies:
SQL> select owner, object_name,object_type from all_objects
where status='INVALID'
order by owner desc, object_type desc , object_name; 2 3
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------
------------------
SYS DBMS_AQADM_SYS PACKAGE BODY
SYS DBMS_IREFRESH PACKAGE BODY
SYS DBMS_JOB PACKAGE BODY
SYS DBMS_PCLXUTIL PACKAGE BODY
SYS DBMS_PRVTAQIP PACKAGE BODY
SYS DBMS_SUMREF_PARENT PACKAGE BODY
SYS DBMS_SUMREF_UTIL PACKAGE BODY
7 rows selected.
I have never seen this before. Although I recompiled them without any
problem, I am wondering how this could happen. Anyone has also expeienced
this?
TIA.
Guang Mei
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Guang Mei
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
