Re: "savepoint" feature

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.

In full agreement with Brian, Sybrand, and Mark but the issue here is that instead of asking how to rollback past a commit you have fixated on the wrong solution ... savpoints.

Take a look at Flashback Query, Flashback Table, Flashback Transaction, and Flashback Version. One or more of them, in 10g, can be utilized to do what you wish.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org