Doc

    Name:   invalobj.sql

    Author: Mark Gurry

    This script lists all objects that are currently 
    invalid.

#

ttitle 'Invalid Object Listing'

SELECT owner, object_type, object_name, status 
FROM   all_objects
WHERE  status = 'INVALID'
ORDER BY owner, object_type, object_name
/
 