错误原因:新增分区的值比当前分区的最大值低
- 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);