- 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.
