27 02 2014

Oracle Flash Back을 이용한 데이타 복구

Flash Back Query 예제

10분전의 데이타를 복구합니다.

insert into dept

select * from dept

AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '10' MINUTE)

where tutorid = '******';

insert into dept

select * from dept

AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '10' MINUTE)

where tutorid = '******';