RE: How to compile objects of type TYPE

From: Richard Ji <rji_at_exenet.com>
Date: Thu, 19 Jul 2001 11:45:38 -0700
Message-ID: <F001.0034EF79.20010719114630@fatcity.com>

alter type type_name compile body;  

Richard Ji

        -----Original Message-----
Sent: Thursday, July 19, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

        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_at_exenet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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 Thu Jul 19 2001 - 13:45:38 CDT