Vamos a configurar la base en modo flashback .
Primero ejecutamos una consulta para conocer si el flashback esta activo o no.
[oracle@sdat0808lx ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 14 14:50:10 2011 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select flashback_on from v$database ; FLASHBACK_ON ------------------ NO