ORA-14074: partition bound must collate higher than that of the last partition
来源:互联网 发布:大数据案例分析ppt 编辑:程序博客网 时间:2024/05/16 07:10
错误原因:新增分区的值比当前分区的最大值低
- create table zhanglei_test (c1 number, c2 varchar2(10))
- partition by range(c1)
- (partition p10 values less than (10),
- partition pmax values less than (maxvalue)
- )
ERROR at line 1:
ORA-14074: partition bound must collate higher than that of the last partition
ORA-14074: 分区界限必须调整为高于最后一个分区界限
解决方案1:
ALTER TABLE ZHANGLEI_TEST SPLIT PARTITION pmax AT (60) INTO (PARTITION P60, PARTITION PMAX) UPDATE GLOBAL INDEXES ;
解决方案2:
- ALTER TABLE ZHANGLEI_TEST DROP PARTITION "PMAX" UPDATE GLOBAL INDEXES
- ALTER TABLE ZHANGLEI_TEST ADD PARTITION "P100" VALUES LESS THAN (100) ;
- ALTER TABLE ZHANGLEI_TEST ADD PARTITION "PMAX" VALUES LESS THAN (MAXVALUE);
- ORA-14074: partition bound must collate higher than that of the last partition
- ORA-14074: partition bound must collate higher than that of the last partition
- 增加分区遇到ORA-14074:partition bound must collate higher...
- ORA-14037: partition bound of partition "T1_198012" is too high
- CFBundleVersion in the Info.plist file must contain a higher version than that of the previously uploaded version.
- CFBundleVersion in the Info.plist file must contain a higher version than that of the previously upl
- CFBundleVersion in the Info.plist file must contain a higher version than that of the previously upl
- ORA-30078: partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
- 《牛客网leetcode20题》Given a string s, partition s such that every substring of the partition is a palind
- [ZOJ1460]The Partition of a Cake
- zoj 1460 The Partition of a Cake
- Ora-14074 When Trying To Add Partition
- Partition
- PARTITION
- partition
- partition
- partition
- Partition
- memcached完全剖析
- Android Camera Framework Stream
- javascript cookies 存、取、删除实例
- 清明节日期的计算方法
- 银行业务调度系统
- ORA-14074: partition bound must collate higher than that of the last partition
- ORA-12154: TNS: 无法解析指定的连接标识符
- AIX版必读收藏贴
- VPN模块的分析
- 当你的程序在朋友的机器上显示丢失msvcr100d.dll的时候
- 内存分配
- ORA-12154: TNS: 无法解析指定的连接标识符(全)
- 定制动态链接和静态链接
- Call通话模块知识点