====== 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;