2 Replies Latest reply: Aug 4, 2013 9:19 AM by Srini Chavali-Oracle RSS

    invalid objects

    user13134974

      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
          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

            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