Oracle Database 12c New Features

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