invalid objects

[Unna]

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

[chduarte]

Actually to migrate from 9i you have to run the script on $ORACLE_HOME/rdbms/admin/u0902000.sql or u0_YOUR_DATABASE_VERSION.sql

[Unna]

Thanks Carlos.

According to 10g migration guide, it recommands to run utlu102i.sql. After running this script, I got:

WARNING: --> Database contains INVALID objects prior to upgrade.
.... USER SYS has 5 INVALID objects.

I thought I need to validate these objects first? And I am not sure if I need to run this u0900010.sql for this migration?


Thanks!

[chduarte]

All database migration you need to run this script u0_YOUR_DATABASE_VERSION.

Check this site: http://download-west.oracle.com/docs...e.htm#i1011372

[ebrian]

You are correct Unna, for upgrade to 10.2 you should run utlu102i.sql prior to the upgrade and resolve any issues it discovers. Once you have resolved all issues, as you mentioned, you don't actually run u0<db_version>.sql any longer, you run catupgrd.sql instead. You should follow the complete processes indicated in Upgrade the Database Manually.

HTH