ORA-14618: cannot drop the last value of subpartition

文档解释

ORA-14618: cannot drop the last value of subpartition

Cause: ALTER TABLE DROP VALUES tried to drop the last value of the subpartition

Action: Cannot execute the command, unless two or more values exist for subpartition

ORA-14618: 不能删除子分区的最后一个值

官方解释

ORA-14618 occurs when attempting to drop the last value of a sub partition. This occurs because it is not possible to have an empty sub partition.

常见案例

正常处理方法及步骤

1. 使用ALTER TABLE语句的 ADD SUBPARTITION子句添加另一个分区

2. 使用ALTER TABLE语句的DROP SUBPARTITION 子句删除原有的子分区

3. 使用ALTER TABLE语句的DROP SUBPARTITION子句删除刚添加的子分区