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

Home -> Community -> Usenet -> c.d.o.misc -> Re: "savepoint" feature

Re: "savepoint" feature

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 12 Jul 2007 14:05:07 -0500
Message-ID: <46966f39$0$16329$88260bb3@free.teranews.com>


mike7411_at_gmail.com wrote:
> I am working with the "savepoint" feature in Oracle, and I noticed
> that a savepoint appears
> to get deleted when a commit occurs. I was wondering if these is an
> easy way to make
> a savepoint that will persist across commits.
>
> Any help is appreciated.
>
> Thank you.
>

A savepoint lets you roll back part of a transaction. Without a savepoint, the only option is to roll back the entire transaction. Once you commit the transaction, it can no longer be rolled back....in part nor in total. So it makes no sense to let you roll back to a savepoint in a committed transaction. This is not possible. If you think you need to rollback to that savepoint, then don't commit!

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com
Received on Thu Jul 12 2007 - 14:05:07 CDT

Original text of this message

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