文档解释
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)提交更改,并查看结果。