In 10g using dbms_flashback one can flashback using timestamp or SCN. If a user accidentally deletes rows or updates rows one can use this to review the data without need to have flashback turned on in the database. Note: SYS can't use dbms_flashback to flashback, Oracle will return "ORA-08185: Flashback not supported for user SYS" … Continue reading How to use DBMS_FLASHBACK? →