SELECT 'alter index ' ||INDEX_NAME || ' REBUILD;' INDEX_NAME, INDEX_TYPE, TABLESPACE_NAME, TABLE_TYPE, STATUS FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE'
SELECT 'alter index ' ||INDEX_NAME || ' REBUILD;' INDEX_NAME, INDEX_TYPE, TABLESPACE_NAME, TABLE_TYPE, STATUS FROM DBA_INDEXES WHERE STATUS = 'UNUSABLE'