Oracle Database 10g Flashback Technology.

Flashback Database allows the DBA to “roll back” a table, set of tables or the entire database to a previous point-in-time.

First of all change the undo_retention parameter of your database.

SQL>show parameter undo_retention;

# The default value is 900 seconds.

Read more >>