CREATE TABLE testrange(
num NUMBER(8) NOT NULL,
var varCHAR2(10)
)
PARTITION BY RANGE (num)
(
PARTITION p9 VALUES LESS THAN (20180901) ,
PARTITION p10 VALUES LESS THAN (20181001) ,
PARTITION p11 VALUES LESS THAN (20181101) ,
PARTITION p12 VALUES LESS THAN (20181201)
);
以上分区表示为:当num的值小于20180901时,新增的记录会插入p9分区,不包含20180901本身
例子:当新增的记录num的值为20180901时,将会插入到p10分区,
SQL> insert into testrange(num,var)values(20180901,'132');
1 row inserted
SQL> SELECT t.* FROM testrange partition(p10) t;
NUM VAR
--------- ----------
20180901 132
SQL>