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 ?