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');

adminschool.net wiki