Yesterday I'd run an updated query and forget to put an where caluse in it result 10,000 rows updated and application ruined because of it. Grace of GOD I have tha back up for that database otherwise I was in a big dumb daze...My question is can we revert back the changes once performed an Update query on DB...I search it on net but not found proper result for it...the final result I come to know that is->Better to put safety before running any update query or prepare back up for your DB ... Any thing perticular you know about this issue..?
I think this is an drawback of database there's must be an option for it...
Joined: Oct 14, 2008
No. If you delete a file from the file system it's gone too, unless you made a backup. If you throw out something in your household it's gone too, unless you made provisions to recreate or retrieve it. Why would a DB be different? If you weren't sure that updating data was the right thing to do, then why did you tell the DB to do it?
On Oracle, starting from version 10g, there is a facility named "flashback query".
You can restore a whole table/tables or only a part of the table (individual rows) without actually restoring complete database from the backup.
If you are using Oracle, read this: http://www.orafaq.com/node/50