martedì 2 aprile 2013

Tip: Solve ORA-14402

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:


ALTER TABLE <my_table> ENABLE ROW MOVEMENT;

Nessun commento:

Posta un commento