Re: How to undo changes / deletes ?
kunt wrote on 23.01.2008 18:51:
> Hi all,
> is there a way to undo changes in a database (e.g. those made because of
> a recent human error, an erroneous delete/update query)
>
> For example reversing all transactions made in the last N days?
>
> On any database? In particular I am most interested in postgres and
> mysql... secondarily Oracle.
>
Oracle comes with a "Flashback" Query where you can query the
data as of xxx minutes in the past.
How far you can travel into the past depends on the system configuration and the
activity on the table.
Thomas |