8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: invalid_objects.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/monitoring/invalid_objects.sql -- Author : Tim Hall -- Description : Lists all invalid objects in the database. -- Call Syntax : @invalid_objects -- Requirements : Access to the DBA views. -- Last Modified: 18/12/2005 -- ----------------------------------------------------------------------------------- COLUMN owner FORMAT A30 COLUMN object_name FORMAT A30 SELECT owner, object_type, object_name, status FROM dba_objects WHERE status = 'INVALID' ORDER BY owner, object_type, object_name;