oracle分区表split

之前版本的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 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)  TABLESPACE "BAIXYU1" NOCOMPRESS ,  PARTITION "PART_02"  VALUES LESS THAN (10)   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)  TABLESPACE "BAIXYU2" NOCOMPRESS ,  PARTITION "PART_03"  VALUES LESS THAN (20)   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)  TABLESPACE "BAIXYU3" NOCOMPRESS ,  PARTITION "PART_04"  VALUES LESS THAN (MAXVALUE)   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)  TABLESPACE "BAIXYU4" NOCOMPRESS ) ;  alter table PARTITION_HB split Partition ptMAX at (50) into (Partition p05 tablespace baixyu1, Partition ptMAX tablespace baixyu4);select partition_name,high_value,partition_position,tablespace_name from user_tab_partitions where table_name='PARTITION_HB';1   PART_01 <Long>  1   BAIXYU12   PART_02 <Long>  2   BAIXYU23   PART_03 <Long>  3   BAIXYU35   P05 <Long>  5   BAIXYU16   PTMAX   <Long>  6   BAIXYU4insert into PARTITION_HB(pid,pdata)values(50,sysdate);50这个临界值是放到了ptmax这个分区里面了，就是小于这个值的放前面的分区，大于等于这个值的数据放后面的分区里。select * from PARTITION_HB partition (ptMAX);1   50      2017/5/26 18:10:38在第五个分区有数据47，我们split47会报错select * from PARTITION_HB partition (p05);1   47      2017/5/26 18:03:01alter table PARTITION_HB split Partition ptMAX at (47) into (Partition p06 tablespace baixyu1, Partition ptMAX tablespace baixyu4);ora-14080或者在max分区中有数据，你split的值比存在的数据小，那么也会报上面的错误