Dear all,

I am preparing my database for 10g migration from 9i, but I have these invalid objects owned by sys: ODCIARGDESC, ODCICOLINFO, ODCICOST, ODCIINDEXINFO, ODCIINDEXINFO.

I ran catproc.sql and utlrp.sql, but still get these invalid objects:
SQL> select object_name, object_type from dba_objects
where owner='SYS'
and status='INVALID'

OBJECT_NAME OBJECT_TYPE
--------------- ------------------
ODCIARGDESC TYPE
ODCICOLINFO TYPE
ODCICOST TYPE
ODCIINDEXINFO TYPE
ODCIINDEXINFO TYPE

When running catproc.sql, I also got these errors:
CREATE OR REPLACE TYPE ODCIxxx AS object
*
ERROR at line 1:
ORA-22308: operation not allowed on evolved type

CREATE OR REPLACE TYPE ODCIxxx AS object
*
ERROR at line 1:
ORA-02303: cannot drop or replace a type with type or table dependents


Are these objects must be valid before migration? And how to valid them?


Thanks,
Unna