Re: Transaction recovery or transaction rollback?

From: Peter <peter_at_nomorenewsspammin.ca>
Date: Fri, 09 May 2003 18:42:30 GMT
Message-ID: <2gtnbvs68u93q2ibvnk99fkosvbgv7vmcd@4ax.com>

On Fri, 09 May 2003 19:58:52 +0800, Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:

>Peter wrote:
>>
>> While I was doing a bunch of insert statements, the Oracle instance
>> suddenly failed. Now, after restarting the instance, should I do a
>> transaction recovery or transaction rollback?
>>
>> Thanks
>
>Assuming you did not commit, then neither ... Oracle has already done it
>for you.
>

I was under the impression that if you committed, then Oracle will do a transaction recovery. If you have not then it will do a transaction rollback.

Thanks Received on Fri May 09 2003 - 13:42:30 CDT