Oracle Rebuild Index Script

    0
    237
    Oracle Rebuild Index Script

    – Rebuild index
    Select ‘alter index ‘||owner||’.’||index_name||’ rebuild ONLINE;’ from dba_indexes d where D.TABLE_NAME =‘PROVIDE_TABLE_NAME’ and D.OWNER=‘PROVIDE_OWNER’;

    — Rebuild Partition index
    Select ‘alter index ‘||index_owner||’.’||index_name||’ rebuild partition ‘||partition_name||’ ONLINE;’ from dba_ind_partitions where INDEX_NAME=‘PROVIDE_INDEX_NAME’;


    — Rebuild Sub Partition index
    Select ‘alter index ‘||index_owner||’.’||index_name||’ rebuild subpartition ‘||subpartition_name||’ ONLINE;’ from dba_ind_subpartitions where INDEX_NAME=‘PROVIDE_INDEX_NAME’;

     Rebuild index