Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to compile objects of type TYPE
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
TYPESYS ODCIARGDESC TYPESYS
TYPESYS ODCICOST TYPESYS ODCIFUNCINFO TYPESYS ODCIINDEXCTX
ODCIRIDLIST
![]() |
![]() |