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

Reply via email to