Talk:Unusable indexes

Current code: Index partitions: SELECT 'alter index '||owner||'.'||index_name ||' rebuild partition '||PARTITION_NAME||' TABLESPACE '||tablespace_name ||';' sql_to_rebuild_index FROM dba_ind_partitions WHERE status = 'UNUSABLE';

Corrected code Index partitions: SELECT 'alter index '||index_owner||'.'||index_name ||' rebuild partition '||PARTITION_NAME||' TABLESPACE '||tablespace_name ||';' sql_to_rebuild_index FROM dba_ind_partitions WHERE status = 'UNUSABLE';

-------------------

Thank for the correction, I fixed the page. Note that you can modify the wiki page yourself and it is appreciated.

Thanks again.

Michel Cadot (talk) 11:11, 25 April 2017 (CEST)