You cannot get back to the top of the cliff you jumped off of.
You cannot rollback after commit. That wouild violate the basic properties of a transaction and a releational database.
http://en.wikipedia.org/wiki/ACID
But ....
(Now don't get your hopes up)
There are 2 features that could be helpful. But they are not simple, and don't apply to most scenerioes.
(1) Flashback queries :
http://download-east.oracle.com/docs...5/adfns_fl.htm
They allow you to select "old" data. It does not allow you to ROLLBACK to this data. But you can access it. That may help you manually "undo" your issue. This feature is not automatically enabled.
(2) If you are doing something complicated, and really just needed to ROLLBACK the last step, you could consider SavePoints.
http://www.stanford.edu/dept/itss/do...3/transact.htm 
2,476
