Rollback committed data

Question

Can committed data be rolled back in oracle? If yes then how can we do this. Please help.

Answer 1

Oracle has several features under the umbrella term FLASHBACK, which in some circumstances allow restoring individual tables or the entire database to an earlier state, without having to do an RMan restore & recover option. The availability of these features depends on (1) which edition of the database you are using, and (2) whether a flash recovery area has been configured. The amount of time that you can flashback depends on the size of the FRA and the amount of activity in the database.

Answer 2

In all RDBMS's, a committed transaction is committed.

As pointed out by @Dave Costa, ORACLE supports Flashback allows you to revert committed changes in some circumstances, without a restore from backup.

Normally, in order to undo committed data, you would have to restore an appropriate backup and then apply changes up to the point you desire.