-- name       : idxchk.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Finds and displays all invalid indexes.
-- limitation : 
--
-- useage     : SQL> @idxchk

set feed off
set linesize 250
set pages 50

spool idxchk.lis

col index_name heading "Index" for a30
col owner heading "Owner" for a30
col table_name heading "Table Name" for a30

select	index_name index_name,
	owner owner,
	table_name table_name
from	all_indexes
where	status<>'VALID'
order by owner, table_name, index_name;

set feed on
set lines 80
set pages 24

spool off