2 Replies Latest reply: Aug 23, 2012 6:35 AM by Helios-GunesEROL RSS

    After Patch set 9.2.0.8_2 invalids

    829857
      Hi,
      i applied the patch set 9.2.0.8 on the top of 9.2.0.1 after utlrp.sql(final step ) i got 2 invalids ...please guide to solve this issue ....

      os: solaris sun sparc-64 bit

      before patch no invalids..


      SQL> select object_name,object_type,status,owner from dba_objects where status='INVALID';

      OBJECT_NAME: TEXTINDEXMETHODS , XPATHINDEXMETHODS
      status: INVALID
      owner :CTXSYS

      Thanks in advance...

      Edited by: 826854 on Aug 17, 2012 3:59 AM