There are five ways to recompile invalid objects in Oracle.

1. DBMS_DDL.ALTER_COMPILE
2. DBMS_UTILITY.COMPILE_SCHEMA
3. UTL_RECOMP
4. UTLRP.SQL - Located: $ORACLE_HOME/rdbms/admin
5. Manually Recompile

Interesting Posts.....

Loading...