다음처럼, 레인지파티션 된 테이블을 만들고

CREATE TABLE PARTITIONED_TABLE1 (C1 NUMBER, C2 CLOB, C3 NUMBER)
             PARTITION BY RANGE (C1, C3)
             (
                PARTITION PART1 VALUES LESS THAN (30, 40),
                PARTITION PART2 VALUES LESS THAN (50, 60),
                PARTITION DEF_PART VALUES LESS THAN (MAXVALUE, MAXVALUE)
             );

글로벌 파티션으로 인덱스를 생성할 수 있어요

CREATE INDEX PARTITIONED_INDEX1 ON PARTITIONED_TABLE1 (C1)
             GLOBAL PARTITION BY RANGE (C1, C3)
             (
                PARTITION IPART1 VALUES LESS THAN (10, 20) INITRANS 3
                PARTITION IPART2 VALUES LESS THAN (30, 40) PCTFREE 10
             );