Oracle/admin
실수로 Data 삭제후 Commit 한 경우 복구 방법(일시적)
소마후니
2015. 9. 14. 19:26
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) ;