오라클 DELETE 이후 삭제된 ROW 복구

/* TB_TEST 테이블의 데이터 삭제 및 반영 */
DELETE FROM TB_TEST WHERE VAL1='123' AND VAL2 IN ('100', '200');
COMMIT;


/* 10분 전, TB_TEST 테이블의 데이터 조회 */
SELECT *
  FROM TB_TEST AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '10' MINUTE)
 WHERE VAL1='123'
   AND VAL2 IN ('100', '200');


/* 10분 전, TB_TEST 테이블에서 삭제된 데이터 복구 */
INSERT INTO TB_TEST
     SELECT *
       FROM TB_TEST AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '10' MINUTE)
      WHERE VAL1='123'
        AND VAL2 IN ('100', '200');