From Satish.Iyer@ci.seattle.wa.us Thu, 19 Jul 2001 13:41:05 -0700 From: "Satish Iyer" Date: Thu, 19 Jul 2001 13:41:05 -0700 Subject: RE: How to compile objects of type TYPE Message-ID: MIME-Version: 1.0 Content-Type: text/plain Thanks Richard, it worked with alter type type_name compile; No "body" needed....   Satish >>> rji@exenet.com 07/19/01 12:46PM >>>alter type type_name compile body;Richard Ji    -----Original Message-----Sent: Thursday, July 19, 2001 3:26 PMTo: Multiple recipients of list ORACLE-L     After our ugprade to 817 from 815 and fully following all the procedures in the manual ended up with the foll. objects as invalid.     Question is how do you compile objects with type being TYPE ?     SQL> select substr(owner,1,10),substr(object_name,1,30),object_type from dba_objects where status <>'VALID';     SUBSTR(OWN SUBSTR(OBJECT_NAME,1,30)       OBJECT_TYPE                                                              SYS        AQ$_DEQUEUE_HISTORY_T          TYPE SYS        ODCIARGDESC                    TYPE SYS        ODCIARGDESCLIST                TYPE SYS        ODCICOST                       TYPE SYS        ODCIFUNCINFO                   TYPE SYS        ODCIINDEXCTX                   TYPE SYS        ODCIRIDLIST                    TYPE     Thanks     Satish --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Richard Ji  INET: rji@exenet.comFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).