2 Replies Latest reply on Aug 4, 2013 2:19 PM by Srini Chavali-Oracle

    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