Validate Invalid Objects in oracle database

We can validate invalid database objects in oracle database using the following ways.

1. Find invalid objects Example:

   1 2 3 4 5

   --To Find the number of invalid objects SQL> select count(*) from dba_objects where status='INVALID';  SQL> select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type;  --To identify the object name and their types and owner SQL> select owner, object_name,object_type from dba_objects where status ='INVALID';

2. Manual method of validation. Example:

   1 2 3 4 5 6

   SQL> Alter procedure <owner>.<procedure_name> compile; SQL > Alter function <owner>.<function_name> compile; SQL> Alter view <owner>.<view_name> compile; SQL> Alter package <owner>.<package_name> compile; SQL>Alter package <owner>.<package_name> compile body; SQL> Alter materialized view <owner>.<Package_name> Compile;