Thread
-
Rollback deletes
Oleg Lebedev <oleg.lebedev@waterford.org> — 2002-10-23T18:36:52Z
Can anybody point me to docs explaining how to rollback recent transactions. Is it possible to rollback recent deletions only? Can I specify the point in time to which I want to rollback? Thanks. Oleg
-
Re: Rollback deletes
Doug McNaught <doug@wireboard.com> — 2002-10-23T18:43:37Z
"Oleg Lebedev" <oleg.lebedev@waterford.org> writes: > Can anybody point me to docs explaining how to rollback recent > transactions. > Is it possible to rollback recent deletions only? > Can I specify the point in time to which I want to rollback? Currently, you can roll back a transaction that is open (not committed) using the ROLLBACK statement. Once you COMMIT, you can't "undo" a transaction (unless you wipe out the database and restore from a backup, or manually reverse all the changes you made). -Doug