ORA-14037: 分区 "P8" 的分区界限…
来源:互联网 发布:林夕梦为什么淘宝禁卖 编辑:程序博客网 时间:2024/05/22 15:25
在使用以下语句列表分区法创建分区表时
SQL> create table T_parttab_str
create table T_parttab_str
(
)
partition by range (PROVINCE_ID)
subpartition by hash (con_autoid)
subpartitions 8 store
(
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'),
)
ORA-14037: 分区 "P8" 的分区界限过高
SQL>
查oracle 错误文档 ORA-14037
ORA-14037 partition bound of partition "string" is toohigh
Cause: High bound of the partition whose name (explicitly specifiedby the
user) is displayed in this message did not collate lower than thatof the
following partition, which is illegal.
Action: Ensure that high bound of every partition (except for thelast one)
collates lower than that of a following partition.
原来是分区p8的分区界限比P9的大了,按通常的理解 9比10小,但是oracle比较字符串时,会首先从第一个字符比较。因为"9">"1",所以会认为"9"<"10",所以就出错了。
将上面的改为
SQL> create table T_parttab_str
Table created
SQL>
建议:
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/pengje/archive/2007/04/04/1551216.aspx
- ORA-14037: 分区 "P8" 的分区界限…
- ORA-14037: 分区 "P8" 的分区界限过高
- ORA-14037: 分区 "P8" 的分区界限过高
- "ORA-01086: savepoint&…
- Unix/Linux 脚本中 "set -e" 的作…
- identifier "tBoolean" is undefie…
- OERR: ORA-3137 "TTC protocol int…
- ch10_ex42 序列的"中值记录"…
- RMAN - "丢失控制文件的恢复"
- Solution for "Waiting for …
- yum groupinstall &quot…
- React-Native "RC…
- variable "l" was set but n…
- What is a Perforce "shelved" fil…
- "No Report Specified"错误的可能…
- Xlib: connection to ":0.0" refus…
- SQL Server 2005 "sa"帐号被禁用 …
- ZZULI_SUMMER_PRACTICE(7) 1177 "…
- 用Packstack 安装 Openstack,无法启动实例,cpu affinity is not supported
- mysql 忘记root密码
- 删除Flashback Log后数据库关闭???
- ORA-12528: TNS: 监听程序: 所有适…
- ORA-25507错误 没有使资源管理器…
- ORA-14037: 分区 "P8" 的分区界限…
- windows 下oracle 10g oem 访问的…
- vi用法
- Linux挂载硬盘
- 2010年03月03日
- Expdp和exp
- 安装oracle运行DBCA出错
- Linux: File not found by glob
- O/S-Error: (OS 33) 另一个程序已…