-- SCN 확인
SELECT a.*
FROM [table] a VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE;
-- UNDO SQL 확인
SELECT undo_sql
FROM FLASHBACK_TRANSACTION_QUERY
WHERE TABLE_NAME='[table]'
AND COMMIT_SCN BETWEEN [시작scn] AND [종료SCN]
ORDER BY start_timestamp desc;
-- TABLE 되돌리기 (SCN)
FLASHBACK TABLE [table] TO SCN [scn];
-- TABLE 되돌리기 (TIMESTAMP)
FLASHBACK TABLE [table] TO TIMESTAMP (SYSTIMESTAMP - INTERVAL 'minute' MINUTE);