Dev Corner

Find Invalid Objects in Oracle Database

Problem
You need to find information about all invalid database objects in an Oracle Database.

Solution

SELECT o.object_name AS object_name,
       o.object_type AS object_type,
       o.owner AS object_schema
  FROM all_objects o
 WHERE o.STATUS = 'INVALID';

Database Administrators (DBA) can query DBA_OBJECTS data dictionary view.

SELECT o.object_name AS object_name,
       o.object_type AS object_type,
       o.owner AS object_schema
  FROM dba_objects o
 WHERE o.STATUS = 'INVALID';