How to find invalid objects in your Oracle Database..

You can use the following Oracle script to observe the invalid objects that exist in your Oracle Database.

select object_name

from dba_objects

where object_type = 'object_type'

and status = 'INVALID';

The following example shows how to modify the above script to find out invalid TRIGGERs of the database.

select object_name

from dba_objects

where object_type = 'TRIGGER'

and status = 'INVALID';