====== FLASHBACK Table ====== - 테이블 생성 create table fb_table (cdate date default sysdate); - 데이타 입력 insert into fb_table values (sysdate); -- sleep 1 insert into fb_table values (sysdate); -- sleep 2 insert into fb_table values (sysdate); commit; - 테이블에서 행 이동 활성화 alter table FB_TABLE enable row movement; - 확인 select row_movement from user_tables where table_name='FB_TABLE'; - Flashback Table flashback table fb_table to timestamp to_timestamp('2016-05-08 05:44:00','YYYY-MM-DD HH24:MI:SS'); - 조회 select * from FB_TABLE;