DELETE 삭제했던 데이터 복구

 

[검색]

SELECT *
FROM '테이블명' AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL '15' MINUTE)
WHERE '검색조건'

SELECT *
FROM '테이블명' AS OF TIMESTAMP TO_TIMESTAMP('20150213 15:00:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE '검색조건'

 

[한방에 INSERT]

INSERT INTO '테이블명'
SELECT *
FROM '테이블명' AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL '15' MINUTE)
WHERE '검색조건'

INSERT INTO '테이블명'
SELECT *
FROM '테이블명' AS OF TIMESTAMP TO_TIMESTAMP('20150213 15:00:00', 'YYYY-MM-DD HH24:MI:SS')
WHERE '검색조건'