Oracle update undo, Massive updates that can generate problems with UNDO tablespace

It is not the first time that I see the need to run a DML which it actually updates many rows, this can be a problem because the UNDO tablespace is not infinite (and not should be).

Recently I had to run an update:

Continue reading