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_NAME PARTITION_NAME STATUS
AMOUNT_IDX PART_1 USABLE
AMOUNT_IDX PART_2 USABLE
AMOUNT_IDX PART_3 USABLE