RECOMPILING INVALID OBJECTS IN 11G

Environment - Oracle 11g on WINDOWS 2008-R2

• Operations such as upgrades,patching and DDL changes can invalidate schema objects.

Steps:-

• First Identify how many invalid objects are there in database.

SQL> select count(*) from dba_objects where status='INVALID';

  COUNT (*) 

    4462

• UTLRP.SQL script located in ORACLE_HOME\RDBMS\ADMIN directory

SQL> @D:\app\oracle\product\11.2.0\dbhome_1\RDBMS\ADMIN\utlrp.sql

• NOW CHECK AGAIN THE INVALID OBJECTS

SQL> SELECT * FROM DBA_OBJECTS WHERE STATUS='INVALID';

     no rows selected

Happy Learning