col table_name for a40 select owner, index_name, table_owner, table_name, status from dba_indexes where status <> 'VALID' order by 1, 2, 3, 4;