Re: Oracle Auto Commit during transaction.

On Mar 14, 3:23�pm, PowerOne <salazar.wi..._at_gmail.com> wrote:
> Hi,
>
> 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:

http://oratips-ddf.blogspot.com/2008/02/dreaded-ora-01555.html

then stop thinking about this.

David Fitzjarrell Received on Sat Mar 15 2008 - 09:00:31 CDT