ORA-14402: Updating Partition Key Column Would Cause A Partition Change

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 17 Dec, 2023
  • 0 Comments
  • 1 Min Read

ORA-14402: Updating Partition Key Column Would Cause A Partition Change

Problem :

While updating a row in partitioned table, got this error.

Solution :

To fix it enable row movement.
SQL> alter table RANGE_TAB enable row movement;
Table altered.
SQL> update RANGE_TAB set TIME_LINE=sysdate-1 where QUANT=50;
3 rows updated.