Identify invalid objects in Oracle:
select object_name from dba_objects where status='INVALID';
select owner, object_name from dba_objects where status='INVALID';