REM  #*****************************************************
REM  # File Name: idxchk.sql
REM  #
REM  # Purpose: Check whether any indexes are invalid 
REM  #
REM  #*****************************************************

SELECT INDEX_NAME, 
       OWNER || '.' || TABLE_NAME AS SOURCE 
FROM ALL_INDEXES 
WHERE STATUS <> 'VALID';