FLASHBACK Table

  1. 테이블 생성 
    create table fb_table (cdate date default sysdate);
  2. 데이타 입력 
    insert into fb_table values (sysdate);
-- sleep 1 
insert into fb_table values (sysdate);
-- sleep 2
insert into fb_table values (sysdate);

commit;
  3. 테이블에서 행 이동 활성화 
    alter table FB_TABLE enable row movement;
  4. 확인 
    select row_movement from user_tables where table_name='FB_TABLE';
  5. Flashback Table 
    flashback table fb_table to timestamp to_timestamp('2016-05-08 05:44:00','YYYY-MM-DD HH24:MI:SS');
  6. 조회 
    select * from FB_TABLE;