Compiling INVALID OBJECTS in database connect to the database. run oracle stored sctipts resided at ?/rdbms/admin/utlrp.sql --Find invalid objects using the following query: SQL> select * from dba_objects where status='INVALID'; SQL> @utlrp.sql --Again Find invalid objects using the following query: SQL> select * from dba_objects where status='INVALID'; ----------------------------------------------------------------------------