dba_objects_invalid.sql

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- Author       : Sameer S Choudhari
-- Description  : Find all invalid objects in the database order by object type & objects_name
-- Call Syntax  : @dba_objects_invalid.sql
-- Last Modified: 20/03/2015
-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SET LINES 220 PAGES 49999
COLUMN owner FORMAT a30
COLUMN object_name FORMAT a30
SELECT owner,
       object_name,
       object_type,
       status
FROM dba_objects
WHERE status != 'VALID'
ORDER BY
  owner,
  object_name,
  object_type;