Re: Oracle Auto Commit during transaction.

On Mar 16, 9:47 pm, PowerOne <salazar.wi..._at_gmail.com> wrote:
> I need a massive update.
>
> So the only way to avoid error and the update
> is to increase the UNDO tablespace size
> or update one by one record.
>
> Thank you.

Go blindly forth and you risk running into a wall.

EXPLAIN PLAN can give you estimates on how much of a resource load this update will be, therefore I would use it BEFORE running the update to see where your problems might lie and what you need to do to fix them.

Your two offerings may not be the ONLY places this update could fail.

David Fitzjarrell Received on Mon Mar 17 2008 - 08:39:01 CDT