In addition to allowing you to read old data, Flashback will allow you to rollback to a point in time, including
returninga single table to a specific state. Flashback database is like PITR without the log files.
It started in 9i and improved dramatically in 10g. 11g has made additional improvements.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/intro007.htm
http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmflash.htm
Lewis R Cunningham
An Expert's Guide to Oracle Technology
http://blogs.ittoolbox.com/oracle/guide/
Postgres Forums
http://postgres.enterprisedb.com/forum.do
--- On Fri, 7/11/08, Simon Riggs <simon@2ndquadrant.com> wrote:
> From: Simon Riggs <simon@2ndquadrant.com>
> Subject: Re: [SQL] Rollback in Postgres
> To: "Scott Marlowe" <scott.marlowe@gmail.com>
> Cc: "samantha mahindrakar" <sam.mahindrakar@gmail.com>, pgsql-sql@postgresql.org
> Date: Friday, July 11, 2008, 2:58 PM
> On Fri, 2008-07-11 at 11:21 -0600, Scott Marlowe wrote:
> > rollback after commit
>
> Are you sure?
>
> Personally I don't think its viable. If it really does
> that it will
> would also need to rollback all transactions whose changes
> depend upon
> the earlier transaction. It would also need to track
> transactions that
> read data changed by an earlier transaction and then makes
> changes to
> the database. It's got no way to track that without
> extensive and costly
> additional infrastructure, since after transaction commit
> row locking
> information can be cleaned up by read-only transactions
> accessing those
> changed data blocks.
>
> Flashback query allows reading data as it was at a certain
> point in the
> past. We might one day provide that, but undoing individual
> transactions
> isn't ever going to be feasible, without unknowable
> risk.
>
> Not jumping on you, just think their marketing is ahead of
> the reality.
>
> --
> Simon Riggs www.2ndQuadrant.com
> PostgreSQL Training, Services and Support
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql