Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> How to compile objects of type TYPE

How to compile objects of type TYPE

From: Satish Iyer <Satish.Iyer_at_ci.seattle.wa.us>
Date: Thu, 19 Jul 2001 11:12:32 -0700
Message-ID: <F001.0034EEE0.20010719112622@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         
TYPESYS        
ODCIARGDESC                    
TYPESYS        

ODCIARGDESCLIST               
TYPESYS        
ODCICOST                       
TYPESYS        
ODCIFUNCINFO                   
TYPESYS        
ODCIINDEXCTX                   

TYPESYS       
ODCIRIDLIST                    

TYPE
Thanks
 

Satish Received on Thu Jul 19 2001 - 13:12:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US