Recently I have partitioned a fact table and today I had to perform the weekly load.
I got into the error:
ORA-14402: updating partition key column would cause a partition change
This error was being raised every time I tried to update the partition field (a date) in a record. To overcome this issue just execute the following: