utlrp.sql to compile all invalid objects in oracle database.

posted Jan 19, 2011 7:56 AM by Sachchida Ojha   [ updated Jan 22, 2012 3:09 PM ]
The utlrp.sql script resides in the ORACLE_HOME/rdbms/admin.
sql>@ORACLE_HOME/rdbms/admin/utlrp.sql
or
@?/rdbms/admin/utlrp.sql