-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- 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;