之前版本的oracle中,创建分区表都会有个maxvalue放超过指定范围的数据
CREATE TABLE "SCOTT"."PARTITION_HB"
( "PID" NUMBER NOT NULL ENABLE,
"PITEM" VARCHAR2(200),
"PDATA" DATE NOT NULL ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BAIXYU"
PARTITION BY RANGE ("PID")
(PARTITION "PART_01" VALUES LESS THAN (5)
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 65536