FlashBack Database On

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 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 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> select flashback_on from v$database ;