set echo off
--------------------------------------------------------------------------------
-- invalid_objs.sql
--
-- Objects - Display invalid objects 
--
-- Usage: @invalid_objs 
--
--------------------------------------------------------------------------------
define psize=100
define lsize=200
define workfile=invalid_objs.ddl
set linesize &&lsize
set pagesize &&psize
--spool &&workfile
--
column owner format a20 
column object_name format a30
Select owner, object_type, object_name, status from dba_objects
      where status != 'VALID' 
      order by owner, object_type;
--spool off
undefine psize
undefine lsize
undefine workfile
-- exit