Search This Blog

Tuesday, September 14, 2010

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.