Enable an Index Partition

Enable an Index Partition example

In oracle database to enable an index partition you must use the command alter index with REBUILD PARTITION keyword.

  

-- enable Index Partition rebuild 
ALTER INDEX amount_idx 
  REBUILD PARTITION part_2; 
	 

Output:

index AMOUNT_IDX altered.

Check partitions

select INDEX_NAME, PARTITION_NAME, STATUS 
from USER_IND_PARTITIONS 
WHERE INDEX_NAME='AMOUNT_IDX';    

Output:

INDEX_NAMEPARTITION_NAMESTATUS
AMOUNT_IDXPART_1USABLE
AMOUNT_IDXPART_2USABLE
AMOUNT_IDXPART_3USABLE