One day i needed to update the key of a partitioned table (usually a date). But the change would made the record move to another partition. Oracle wouldn’t let me do that and raised an error :

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

 

To avoid that error and enable that move of records from one partition to another you will have to use the following statement :

 

ALTER TABLE xYz ENABLE ROW MOVEMENT;

Right after that, you can do your update.

What a tip uh ?