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