Oracle Database Check invalid objects in database

Oracle Database – how to check invalid objects in database

  SELECT owner,

         object_name,

         object_type,

         status

    FROM dba_objects

   WHERE status = ‘INVALID’

ORDER BY owner,

         object_name,

         subobject_name,

         object_type;

Leave a Comment

Your email address will not be published.