ORA-14081: new partition name must differ from the old partition name

文档解释

ORA-14081: new partition name must differ from the old partition name

Cause: User entered ALTER TABLE/INDEX RENAME PARTITION specifying which is identical to the name of the partition being renamed

Action: Ensure that the new partition name is different from the name of any (including the one being renamed) existing partition of a given table or index

ORA-14081意味着,当更改表分区名称时,新的分区名称必须与旧的分区名称不同。

官方解释

常见案例

正常处理方法及步骤

(1)确定分区名称是否重复,如果重复,需要指定不同的分区名称;

(2)根据设计要求,使用ALTER TABLE RENAME PARTITION来更改表分区的名称,确保新的分区名称比老的分区名称不同;

(3)提交更改,并查看结果。

你可能感兴趣的