본문 바로가기

Oracle/admin

실수로 Data 삭제후 Commit 한 경우 복구 방법(일시적)

SQL> insert into emp (empno, ename, job, mgr, hiredate, sal, comm, deptno)
    2     select empno, ename, job, mgr, hiredate, sal, comm, deptno
    3        from emp as of timestamp ( systimestamp - interval '10' minute) ;