ORA-14272: only a partition with higher bound can be reused

文档解释

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. 如果一定要改变范围,那么就要先删除这个分区,然后建立一个新的有高范围的分区。

你可能感兴趣的