Identify Invalid Objects

The DBA_OBJECTS view can be used to identify invalid objects using the following query.

    SELECT owner,
           object_type,
           object_name,
           status
    FROM   dba_objects
    WHERE  status = 'INVALID' and owner='ownername'
    ORDER BY owner, object_type, object_name;