ORA-14037: 分区 "P8" 的分区界限过高
来源:互联网 发布:阿里云git 编辑:程序博客网 时间:2024/05/05 00:03
create table T_parttab_str
(
PROVINCE_ID varchar2(8) not null,
MATER_TYPE NVARCHAR2(2)
)
partition by range (PROVINCE_ID)
(
PARTITION p1 VALUES LESS THAN ('2'),
PARTITION p2 VALUES LESS THAN ('3'),
PARTITION p3 VALUES LESS THAN ('4'),
PARTITION p4 VALUES LESS THAN ('5'),
PARTITION p5 VALUES LESS THAN ('6'),
PARTITION p6 VALUES LESS THAN ('7'),
PARTITION p7 VALUES LESS THAN ('8'),
PARTITION p8 VALUES LESS THAN ('9'),
PARTITION p9 VALUES LESS THAN ('10'),
PARTITION p10 VALUES LESS THAN ('11'),
PARTITION p11 VALUES LESS THAN ('12'),
PARTITION p32 VALUES LESS THAN (maxvalue)
)
ORA-14037: 分区 "P8" 的分区界限过高
分区p8的分区界限比P9的大了,按通常的理解9比10小,但是Oracle比较字符串时,会首先从第一个字符比较。因为"9">"1",所以会认为"9"<"10",所以就出错了。
将上面的改为
create table T_parttab_str
(
PROVINCE_ID varchar2(8) not null,
MATER_TYPE NVARCHAR2(2)
)
partition by range (PROVINCE_ID)
(
PARTITION p1 VALUES LESS THAN ('02'),
PARTITION p2 VALUES LESS THAN ('03'),
PARTITION p3 VALUES LESS THAN ('04'),
PARTITION p4 VALUES LESS THAN ('05'),
PARTITION p5 VALUES LESS THAN ('06'),
PARTITION p6 VALUES LESS THAN ('07'),
PARTITION p7 VALUES LESS THAN ('08'),
PARTITION p8 VALUES LESS THAN ('09'),
PARTITION p9 VALUES LESS THAN ('10'),
PARTITION p10 VALUES LESS THAN ('11'),
PARTITION p11 VALUES LESS THAN ('12'),
PARTITION p32 VALUES LESS THAN (maxvalue)
)
建议:范围分区时,分区键尽量不用字符型。如果字符型时要注意保持字符位数一致以避免出现意想不到的情况。
(
PROVINCE_ID varchar2(8) not null,
MATER_TYPE NVARCHAR2(2)
)
partition by range (PROVINCE_ID)
(
PARTITION p1 VALUES LESS THAN ('2'),
PARTITION p2 VALUES LESS THAN ('3'),
PARTITION p3 VALUES LESS THAN ('4'),
PARTITION p4 VALUES LESS THAN ('5'),
PARTITION p5 VALUES LESS THAN ('6'),
PARTITION p6 VALUES LESS THAN ('7'),
PARTITION p7 VALUES LESS THAN ('8'),
PARTITION p8 VALUES LESS THAN ('9'),
PARTITION p9 VALUES LESS THAN ('10'),
PARTITION p10 VALUES LESS THAN ('11'),
PARTITION p11 VALUES LESS THAN ('12'),
PARTITION p32 VALUES LESS THAN (maxvalue)
)
ORA-14037: 分区 "P8" 的分区界限过高
分区p8的分区界限比P9的大了,按通常的理解9比10小,但是Oracle比较字符串时,会首先从第一个字符比较。因为"9">"1",所以会认为"9"<"10",所以就出错了。
将上面的改为
create table T_parttab_str
(
PROVINCE_ID varchar2(8) not null,
MATER_TYPE NVARCHAR2(2)
)
partition by range (PROVINCE_ID)
(
PARTITION p1 VALUES LESS THAN ('02'),
PARTITION p2 VALUES LESS THAN ('03'),
PARTITION p3 VALUES LESS THAN ('04'),
PARTITION p4 VALUES LESS THAN ('05'),
PARTITION p5 VALUES LESS THAN ('06'),
PARTITION p6 VALUES LESS THAN ('07'),
PARTITION p7 VALUES LESS THAN ('08'),
PARTITION p8 VALUES LESS THAN ('09'),
PARTITION p9 VALUES LESS THAN ('10'),
PARTITION p10 VALUES LESS THAN ('11'),
PARTITION p11 VALUES LESS THAN ('12'),
PARTITION p32 VALUES LESS THAN (maxvalue)
)
建议:范围分区时,分区键尽量不用字符型。如果字符型时要注意保持字符位数一致以避免出现意想不到的情况。
0 0
- ORA-14037: 分区 "P8" 的分区界限过高
- ORA-14037: 分区 "P8" 的分区界限过高
- ORA-14037 分区界限过高的原因分析及解决
- ORA-14037: 分区 "P8" 的分区界限…
- ORA-14300: 分区关键字映射到超出允许的最大分区数的分区
- 分区split ORA-14074
- 分区
- 分区
- 分区
- 分区
- 分区
- 分区
- 分区
- 分区
- 分区
- 分区
- 分区
- 分区
- OracleOraDb11g_home1TNSListener服务启动后停止
- Java语言程序设计-基础篇-4.34习题--游戏:石头剪刀,布
- wireshake抓包分析
- mybatis-(一对一关联)
- 四、资源和对象的区别、抽象类和抽象方法、重载技术、接口interface
- ORA-14037: 分区 "P8" 的分区界限过高
- list泛型实现
- SQL*Loader-522: lfiopn failed for file (xxx.log)
- ios8及Xcode6下启动界面配置
- Ubuntu Error: the system network service is not compatible with this version
- openstack登陆dashboard连接失败:[Errno 111] Connection refused
- Java容器类Collection、List、ArrayList、Vector及map、HashTable、HashMap
- oracle is not in the sudoers file.This incident will be reported
- C#中的序列化和反序列化小例