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
|
- RE: How to compile objects of type TYPE Satish Iyer
- RE: How to compile objects of type TYPE Richard Ji
- RE: How to compile objects of type TYPE Richard Ji
- RE: How to compile objects of type TYPE Satish Iyer