invalid objects after migration 8i to 10g
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: invalid objects after migration 8i to 10g

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    invalid objects after migration 8i to 10g

    Hi beloved Friends,

    I am now migrating my 8.1.7(aix 4.3.3) database to
    10g(10.1.0.3) AIX 5L.
    One thing good about OEM 10g is that it warns me that I still have
    invalid objects in my database,(even after running the pupbld.sql as
    what the patch installer advised) in the monitor screen it says I have
    6 objects are invalid in the PUBLIC schema and 14 objects are invalid
    in the SYS schema. But when I select count(*) from dba_objects where
    status='INVALID' i got a total of 61 objects. Why is this so?

    I tried recompiling the object for PUBLIC and SYS:

    SQL> alter SYNONYM PUBLIC.ALL_REPGROUPED_COLUMN compile;
    alter SYNONYM PUBLIC.ALL_REPGROUPED_COLUMN compile
    *
    ERROR at line 1:
    ORA-00995: missing or invalid synonym identifier
    =============================================================
    How do I compile a public object?
    =============================================================
    SQL> alter VIEW SYS._ALL_REPGROUPED_COLUMN compile;
    alter VIEW SYS._ALL_REPGROUPED_COLUMN compile
    *
    ERROR at line 1:
    ORA-00911: invalid character
    =============================================================
    How do I compile an object with a leading "_" name?
    =============================================================
    SQL> alter PACKAGE BODY SYS.DBMS_SQLTUNE compile;
    alter PACKAGE BODY SYS.DBMS_SQLTUNE compile
    *
    ERROR at line 1:
    ORA-00922: missing or invalid option
    =============================================================
    How do I compile a package body?
    =============================================================


    Thanks a lot in avance

    Ms Congeniality III

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    alter package body OWNER.object_name compile body;

    synonyms doesn't have to be compile, check with its
    previous existense.

    But when I select count(*) from dba_objects where status='INVALID' i got a total of 61 objects. Why is this so?
    'cause dba_objects includes all schemas.

  3. #3
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    yes dear, all i have selectd are from PUBLIC and SYS only ...well i just got 1 from my user schema.
    I keep on recompiling the SYS objects and it did successfully. but when i check it theres another gets invalid like domino effect.

    Thanks a lot

    Ms Congeniality III

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    public isnt a user, it doesnt own any objects so nothing to compile.

    Run @?/rdbms/admin/utlrp to do the invalid objects

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