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

Thread: utl_recomp_errors;

  1. #1
    Join Date
    May 2008
    Posts
    95

    Exclamation utl_recomp_errors;

    Dear Friends,

    Please see the following, when I trying to recompile invalid objects I got it.

    SQL> select owner, table_name
    from dba_tables
    where tablespace_name = 'SYSTEM'
    and owner not in ('SYS', 'SYSTEM'); 2 3 4

    OWNER TABLE_NAME
    ------------------------------ ------------------------------
    OUTLN OL$
    OUTLN OL$HINTS
    OUTLN OL$NODES

    SQL> select obj#, compile_err from utl_recomp_errors;

    OBJ#
    ----------
    COMPILE_ERR
    --------------------------------------------------------------------------------
    73037
    ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_PRODUCTS
    _USED_BY
    ORA-00980: synonym translation is no longer valid

    73039
    ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_PRODUCT_
    PRIVS
    ORA-00980: synonym translation is no longer valid

    OBJ#
    ----------
    COMPILE_ERR
    --------------------------------------------------------------------------------

    73041
    ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_USERS
    ORA-00980: synonym translation is no longer valid

    73043
    ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_USER_PRI
    VILEGES
    ORA-00980: synonym translation is no longer valid

    OBJ#
    ----------
    COMPILE_ERR
    --------------------------------------------------------------------------------

    73045
    ORA-04045: errors during recompilation/revalidation of PUBLIC.QUEST_COM_PRODUCTS

    ORA-00980: synonym translation is no longer valid



    Thanks in advance..

    Best Regards,

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    your synonyms are no longer valid - just like the error says

  3. #3
    Join Date
    May 2008
    Posts
    95

    Exclamation

    Thanks davey, how to resolve this.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    fix your synonyms!

  5. #5
    Join Date
    May 2008
    Posts
    95

    Exclamation

    But already I dropped that schema.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

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