DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: invalid objects

  1. #1
    Join Date
    Nov 2000
    Posts
    164

    invalid objects

    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

  2. #2
    Join Date
    Dec 2006
    Location
    Brazil
    Posts
    36
    Actually to migrate from 9i you have to run the script on $ORACLE_HOME/rdbms/admin/u0902000.sql or u0_YOUR_DATABASE_VERSION.sql
    Regards,

    Carlos Duarte
    Oracle Applications DBA

  3. #3
    Join Date
    Nov 2000
    Posts
    164
    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!

  4. #4
    Join Date
    Dec 2006
    Location
    Brazil
    Posts
    36
    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
    Regards,

    Carlos Duarte
    Oracle Applications DBA

  5. #5
    Join Date
    Apr 2006
    Posts
    377
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width