Database Error Messages

ORA-14402

Updating partition key columns is not allowed.

Cause

An UPDATE statement attempted to change the value of the partition key columns for the table, which would migrate the row to another partition. This is not allowed because it can cause a partition change.


Action

Do one of the following:

  • Do not attempt to update the partition key columns.
  • Ensure that the new partition key values result in the row remaining in the same partition.
  • Use the ALTER TABLE ... ENABLE ROW MOVEMENT statement to allow rows to move to another partition when the partition key is updated.