사용자 도구

사이트 도구


dbms:oracle:admin:flashback:transaction_backout

문서의 이전 판입니다!


flashback transaction backout

  1. 사전작업
    alter database add supplemental log data;
    alter database add supplemental log data (primary key) columns; 
    grant execute on dbms_flashback to hr;
    grant select any transaction to hr;
  2. 스크립트 실행
    connect hr/oracle
    select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
    
    INSERT INTO hr.regions VALUES (5,'Pole'); 
    COMMIT;
    
    UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5;
    UPDATE hr.regions SET region_name='North and South Poles' WHERE region_id = 5;
    COMMIT;
    
    INSERT INTO hr.countries VALUES ('TT','Test Country',5); 
    COMMIT;
    
    select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
    
    connect / as sysdba
    ALTER SYSTEM ARCHIVE LOG CURRENT;
dbms/oracle/admin/flashback/transaction_backout.1462656017.txt.gz · 마지막으로 수정됨: 2016/05/08 06:20 저자 starlits