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

Wakad : +919325408926 Icon

kalewadi : +918983069523 Icon

kharadi : +919325408926

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.