Reputation: 3833
Is there any method to redo changes in Oracle db after commit? Please can anyone guide me
P.s. Oracle version I'm using is 10.1.1.8.
Upvotes: 3
Views: 134
Reputation: 3833
Another interesting link i found.
http://oracleflash.com/25/Using-Oracle-LogMiner-to-undo-incorrectly-committed-changes.html
Upvotes: 0
Reputation: 21851
Flashback queries can help. Have a look at this article which briefs you on the details about it.
Flashback query allows a user to view the data quickly and easily the way it was at a particular time in the past, even when it is modified and committed, be it a single row or the whole table.
Oracle documentation on Flashback query is here.
Upvotes: 3