Tag: RESTORE POINT ONLY

Flashback is OFF

SQL>  select FLASHBACK_ON from v$database;

FLASHBACK_ON
------------------
NO

Flashback is ON

SQL>  select FLASHBACK_ON from v$database;

FLASHBACK_ON
------------------
YES

Flashback is OFF but with Restore Point

SQL> select FLASHBACK_ON from v$database;

FLASHBACK_ON
------------------
RESTORE POINT ONLY