kunt wrote:
> 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.
>
> Thank you

delete from xyz;
rollback;
and there cannot be an autocommit (if so you are hosed) -- if not, the
rollback.

If it is recent - as in an hour ago -- it is called RESTORE FROM BACKUP

There is no "recycle bin" in Mysql.


Oracle has a "flashback area" not sure how extensive it can be, but no
other DB has that level of recovery.

Oracle also has logminer which allows you to restore from backup up to
the point of "doing something stupid" and then extract all other
transactions except the one that caused your problem.