Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > Re: How to undo...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 8 Topic 3081 of 3295
Post > Topic >>

Re: How to undo changes / deletes ?

by Thomas Kellerer <FJIFALSDGVAF@[EMAIL PROTECTED] > Jan 24, 2008 at 07:33 PM

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
 




 8 Posts in Topic:
How to undo changes / deletes ?
kunt <kunt@[EMAIL PROT  2008-01-23 18:51:45 
Re: How to undo changes / deletes ?
DonO <don.orban@[EMAIL  2008-01-23 12:16:04 
Re: How to undo changes / deletes ?
Michael Austin <mausti  2008-01-23 14:45:04 
Re: How to undo changes / deletes ?
Lennart <Erik.Lennart.  2008-01-24 10:24:55 
Re: How to undo changes / deletes ?
Thomas Kellerer <FJIFA  2008-01-24 19:33:48 
Re: How to undo changes / deletes ?
Johan Nel <johan555.ne  2008-04-24 16:28:28 
Re: How to undo changes / deletes ?
Marco Mariani <marco@[  2008-04-28 13:04:41 
Re: How to undo changes / deletes ?
Philipp Post <Post.Phi  2008-04-29 06:21:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 10:18:11 CST 2008.