最近文章

最近文章
您当前所在位置:主页 > 最近文章 >

ORA-14037 :解决办法

发布日期:2018年11月16 编辑:

ORA-14037: 分区"P2" 的分区界限过高
 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 错误文档ORA-14037
ORA-14037 partition bound of partition "string" is too high
Cause: High bound of the partition whose name (explicitly specified by the
user) is displayed in this message did not collate lower than that of the
following partition, which is illegal.
Action: Ensure that high bound of every partition (except for the last one)
collates lower than that of a following partition.
问题原因:是分区p2的分区界限比P3的大了,按通常的理解9 比10小,但是oracle比较字符串时,会首先从第一个字符比较。因为"9">"1",所以会认为"9"<"10",所以就出错了。
解决办法:
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)
);

作者 zyuc_wangxw

http://www.bkjia.com/oracle/484839.htmlwww.bkjia.comtruehttp://www.bkjia.com/oracle/484839.htmlTechArticleORA-14037: 分区P2 的分区界限过高 CREATE TABLE PROVINCE_INFO ( PROVINCE_ID VARCHAR2(8) NOT NULL, PROVINCE_NAME VARCHAR2(40) NOT NULL, CREATE_DT DATE ) PARTITION BY RANGE (PR...

本文源自: 凯发国际

< 上一篇:oracle游标cursor简单使用

> 下一篇:没有了