Flashback

It's possible to do the flashback for:

- table

- db (open db with resetlogs)

- tablespace

v$flashback_database_stat

v$flashback_database_log

grant execute on DBMS_FLASHBACK to POWER_USER;

alter system set UNDO_MANAGEMENT=AUTO;

alter system set UNDO_RETENTION=100000;

select * from some_table as of timestamp to_timestamp('12/12/2005 19:00','DD/MM/YYYY HH24:MI');