ORA-14402: updating partition key column would cause a partition change

ORA-14402: updating partition key column would cause a
partition change

Question Posted / guest

2 Answers
9975 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-14402: updating partition key column would cause a partition change..

Answer / virender sharma

alter table <partition name> enable row movement;

after that fire update command it will allow update

Is This Answer Correct ?

5 Yes

0 No

ORA-14402: updating partition key column would cause a partition change..

Answer / guest

Cause: An UPDATE statement attempted to change the value of
a partition key column causing migration of the row to
another partition

Action: Do not attempt to update a partition key column or
make sure that the new partition key is within the range
containing the old partition key.

Please add more information about this Error

Is This Answer Correct ?

4 Yes

0 No

Post New Answer