Oracle Database 12c New Features

ORA-14262: new subpartition name must differ from the old subpartition name

ORA-14262: new subpartition name must differ from the old subpartition name


Cause:


User entered ALTER TABLE/INDEX RENAME SUBPARTITION specifying which is identical to the name of the subpartition being renamed



Action:


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