ORA-14329: domain index [sub]partitions cannot be renamed in this clause

文档解释

ORA-14329: domain index [sub]partitions cannot be renamed in this clause

Cause: The user tried to rename a domain index [sub]partition in the UPDATE INDEXES clause of a ALTER TABLE MOVE [SUB]PARTITION operation. This is not allowed.

Action: Leave the name blank or use the same name.

ORA-14329 错误是指在此子句中，域索引分区不能重命名。

官方解释

您正在尝试重命名域索引分区，但是这是不允许的。该SQL语句会引发ORA-14329错误消息。

常见案例

ORA-14329可以引发如下错误：

SQL> alter index emp_ind rename partition p1 to p2;

alter index emp_ind rename partition p1 to p2

*

ERROR at line 1:

ORA-14329: domain index [sub]partitions cannot be renamed in this clause

正常处理方法及步骤

1.使用DROP PARTITION子句从表中删除该分区。

2.使用ADD PARTITION子句将具有新名称的分区添加回表中。

3.重建索引，使它可以识别新分区。