Can there be any approach to redo alterations in Oracle db after commit? Please can anybody guide me
P.s. Oracle version I am using is 10.1.1.8.
Flashback queries might help. Take a look at this article which briefs yourself on the particulars about this.
Flashback query enables a person to see the information rapidly and simply the actual way it was in a particular time previously, even when it's modified and committed, whether it's a single row or even the whole table.
Oracle documentation on Flashback totally here.
Another interesting link i discovered.