Flashback =========== CREATE TABLE T1 ( id NUMBER(10) ); ALTER TABLE T1 ENABLE ROW MOVEMENT; SELECT current_scn FROM v$database; CURRENT_SCN ----------- 715315 INSERT INTO flashback_table_test (id) VALUES (1); COMMIT; SELECT current_scn FROM v$database; CURRENT_SCN ----------- 715340 FLASHBACK TABLE flashback_table_test TO SCN 715315; SELECT COUNT(*) FROM flashback_table_test; COUNT(*) ---------- 0 FLASHBACK TABLE flashback_table_test TO SCN 715340; SELECT COUNT(*) FROM flashback_table_test; COUNT(*) ---------- 1 Flashback of tables can also be performed using timestamps. FLASHBACK TABLE T1 TO TIMESTAMP TO_TIMESTAMP('2016-29-06 13:51:00', 'YYYY-MM-DD HH24:MI:SS');