ORA-14037 :解决办法

最新推荐文章于 2025-03-10 21:15:52 发布

原创最新推荐文章于 2025-03-10 21:15:52 发布 · 3.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#less #null #oracle #table #date #string

Oracle 专栏收录该内容

29 篇文章

订阅专栏

本文介绍Oracle中创建范围分区表时遇到ORA-14037错误的原因及解决办法，该错误通常是因为分区边界设置不当导致，文中通过调整分区值解决了问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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)
);