Re: Oracle Auto Commit during transaction.
Date: Sat, 15 Mar 2008 07:00:31 -0700 (PDT)
On Mar 14, 3:23 pm, PowerOne <salazar.wi..._at_gmail.com> wrote:
> If I send an Update like this:
> UPDATE MyTable SET Field1 = value
> WHERE Field2 = value2;
> there is a way that Oracle make a commit every X records updated?
> Note: this update can alter thousand of records at the same time.
> Thank you.
No, and you don't want to do that. It's a sure technique to generate ORA-01555 errors and, thus, kill your overall update. Read here:
then stop thinking about this.
David Fitzjarrell Received on Sat Mar 15 2008 - 09:00:31 CDT