UNUSABLE Index Rebuild Script

select ‘alter index ‘ || owner || ‘.’ || index_name || ‘ rebuild storage (FREELISTS 2 ) tablespace KKKK parallel 12′ ||’;’ || chr(10) || ‘alter index ‘ || owner || ‘.’ || index_name || ‘ rebuild storage (FREELISTS 2 FREELIST GROUPS 2) tablespace ‘|| tablespace_name ||’ parallel 12;’ from dba_indexes WHERE status = ‘UNUSABLE’ order by tablespace_name, INDEX_name;