1.问题现象
TEST@czhpdb1 > alter table test_part add partition p1 values less than(1000);
alter table test_part add partition p1 values less than(1000)
*
ERROR at line 1:
ORA-14074: partition bound must collate higher than that of the last partition
2.问题原因
表已有分区partition key max value大于要加入的partition key,不能通过alter table add partition语句添加分区。
3.问题解决
通过split分区增加分区
# 将partition p4在3000值分界,分割为p3,p4两个分区
TEST@czhpdb1 > alter table test_part split partition p4 at (3000) into (partition p3,partition p4);
Table altered.