Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction recovery or transaction rollback?

Re: Transaction recovery or transaction rollback?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 09 May 2003 19:58:52 +0800
Message-ID: <3EBB97FC.5EE6@yahoo.com>


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.

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"
Received on Fri May 09 2003 - 06:58:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US