SOLVED

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

Asked by OracleDba••17 views•oracle
1
2
3
4
5
ORA-14402: Updating Partition Key Column Would Cause A Partition Change

Problem :

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

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
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.
OracleDba•

Post Your Solution