Thanks Richard, it worked with
alter type type_name compile;
No "body" needed....
Satish
>>> rji_at_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
<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: <A
href="
http://www.orafaq.com">
http://www.orafaq.com--Author: Richard
Ji INET: rji_at_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_at_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).
Received on Thu Jul 19 2001 - 15:41:05 CDT
