文档解释
ORA-14272: only a partition with higher bound can be reused
Cause: User attempt to reuse a lower-bound partition in ALTER TABLE MERGE PARTITIONS statement as the resulting partition which is illegal.
Action: Use the higher-bound partition to be the resulting partition or specify a new partition name
这是Oracle数据库提示的一个错误消息,通常在当用户试图对一个表分区作出ALTER操作时引发。但这次ALTER操作是给表中存在的一个分区增加或改变范围的。
官方解释
ORA-14272 is an Oracle Database error raised when the user attempts to reuse a partition by changing its boundaries. The operation is illegal because a lower bound can not be reused, but only a higher bound can be reused.
常见案例
当条件满足下表中所有分区,这些分区就可以被重用,但当用户试图修改表中某个分区,使其低于现有分区的范围,便会出现此错误。
正常处理方法及步骤
1. 确保给定的数据(新范围)比现有表中分区范围高。
2. 如果一定要改变范围,那么就要先删除这个分区,然后建立一个新的有高范围的分区。