All,

I am updating the table based on the leading partition key and i got the error message.

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

Again i changed the table as below.

alter table inventory ENABLE ROW MOVEMENT;

Now it works fine. I have two questions.

1. When we update the partition key, does oracle really move the data to different partition or it deletes the record in current partition and insert into another partition?.

2. Is it overhead when we update parition key? Any extra cost?