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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [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).