ORA-14037: Solution

ORA-14037: partition limit for partition "P2" is too high
Create table PROVINCE_INFO
(
PROVINCE_ID VARCHAR2 (8) not null,
PROVINCE_NAME VARCHAR2 (40) not null,
CREATE_DT DATE
)
Partition by range (PROVINCE_ID )(
PARTITION P1 values less than ('8 '),
PARTITION P2 values less than ('9 '),
PARTITION P3 values less than ('10 '),
PARTITION P4 values less than ('11 '),
PARTITION P5 values less than (MAXVALUE)
);


 
Oracle error document ORA-14037
ORA-14037 partition bound of partition "string" is too high
Cause: High bound of the partition whose name (explicitly specified by
User) is displayed in this message did not collate lower than that of
Following partition, which is illegal.
Action: Ensure that high bound of every partition (could t for the last one)
Collates lower than that of a following partition.
Cause: partition p2 has a larger partition limit than that of P3. Generally, partition p2 is 9 to 10 smaller. However, when oracle compares strings, it first compares them with the first character. Because "9"> "1", you will think "9" <"10", so an error occurs.
Solution:
Create table PROVINCE_INFO
(
PROVINCE_ID varchar2 (8) not null,
PROVINCE_NAME varchar2 (40) not null,
CREATE_DT DATE
)
Partition by range (PROVINCE_ID)
(
PARTITION p1 values less than ('08 '),
PARTITION p2 values less than ('09 '),
PARTITION p3 values less than ('10 '),
PARTITION p4 values less than ('11 '),
PARTITION p5 values less than (maxvalue)
);

Author: zyuc_wangxw