invalid sys package bodies

From: Guang Mei <zlmei_at_hotmail.com>
Date: Mon, 03 Feb 2003 07:49:32 -0800
Message-ID: <F001.00542209.20030203074932@fatcity.com>

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: zlmei_at_hotmail.com

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: ListGuru_at_fatcity.com (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). Received on Mon Feb 03 2003 - 09:49:32 CST