ORA-14074: partition bound must collate higher than that of the last partition

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.