Invalid Objects

-- ##############################################################################
--       INVALID OBJECTS
--       http://www.oracle-base.com/articles/misc/recompiling-invalid-schema-objects.php
-- ##############################################################################

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

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*