Create Range-Partitioned Global Index

Create Range-Partitioned Global Index example

  
-- create Range-Partitioned Global Index 
CREATE INDEX amount_idx ON orders (amount)
   GLOBAL PARTITION BY RANGE (amount)
      (PARTITION p1 VALUES LESS THAN (500),
       PARTITION p2 VALUES LESS THAN (1500),
       PARTITION p3 VALUES LESS THAN (MAXVALUE));

Output:

index AMOUNT_IDX created.

Check indexes

select INDEX_NAME, INDEX_TYPE, PARTITIONED
from USER_INDEXES
WHERE table_name='ORDERS';    

Output:

INDEX_NAMEINDEX_TYPEPARTITIONED
PK_ORDER_IDNORMALNO
ORDERS_UNIQUE_INDEXNORMALNO
AMOUNT_IDXNORMALYES