This discussion is archived
2 Replies Latest reply: Aug 4, 2013 7:19 AM by Srini Chavali-Oracle RSS

invalid objects

user13134974 Newbie
Currently Being Moderated

Hi

 

I am going to upgrade oracle 10.2.0.3 to oracle 11.2.0.3 . As a part of up gradation I compile all object which were invalid but the following objects are not  validated

 

SQL> select object_name,object_type,status from dba_objects

  2  where owner='PUBLIC' and status='INVALID';

DB_ALERT

SYNONYM             INVALID

 

 

JOB_MONITOR

SYNONYM             INVALID

 

 

APP_MONITOR

SYNONYM             INVALID

 

 

----------------------------------------------

 

 

SQL> alter public synonym JOB_MONITOR compile;

alter public synonym JOB_MONITOR compile

*

ERROR at line 1:

ORA-00980: synonym translation is no longer valid

 

 

could you please help me to compile the above objects.

 

 

Regard

 

 

Rabi

  • 1. Re: invalid objects
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    ORA-00980:synonym translation is no longer valid
    Cause:The synonym used is based on a table, view, or synonym that no longer exists.
    Action:Replace the synonym with the name of the object it references or re-create the synonym so that it refers to a valid table, view, or synonym.

     

     

     

     

     

    Also you can use @?/rdbms/admin/utlrp.sql

  • 2. Re: invalid objects
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated

    Pl post OS details and the steps used to perform the upgrade - were any errors recorded in the upgrade log file ? These seem to be custom objects - what are they referring to ?

     

    HTH
    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points