Rebuild an Index Partition

Rebuild an Index Partition example

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

  

-- create Range-Partitioned Global Index 
CREATE INDEX amount_idx ON orders (amount)
   GLOBAL PARTITION BY RANGE (amount)
      (PARTITION part_1 VALUES LESS THAN (1000),
       PARTITION part_2 VALUES LESS THAN (2000),
       PARTITION part_3 VALUES LESS THAN (MAXVALUE));
	   
-- rebuild Index Partition
ALTER INDEX AMOUNT_IDX
  REBUILD PARTITION PART_1 NOLOGGING; 
	 

Output:

index AMOUNT_IDX created.
index AMOUNT_IDX altered.

Check partitions

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

Output:

INDEX_NAMEPARTITION_NAMELOGGING
AMOUNT_IDXPART_1NO
AMOUNT_IDXPART_2YES
AMOUNT_IDXPART_3YES