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_NAME	INDEX_TYPE	PARTITIONED
PK_ORDER_ID	NORMAL	NO
ORDERS_UNIQUE_INDEX	NORMAL	NO
AMOUNT_IDX	NORMAL	YES

↑