FLASHBACK TABLE :
conditions : user menDelete table
simualation :
SQL> connect scott/password_scott
connected.
SQL>delete emp;
15 rows deleted.
SQL>commit;
commit complete.
cara2 :
1. SQL> flashback table emp to scn ?
untuk mengetahui scn berapa, lakukan hal di bawah ini
SQL>select versions_startscn-1 as flashback_scn,
versions_operation as ops,
empno,ename,sal
from emp versions between scn minvalue and maxvalue
where 1=1
and versions_start_scn is not null
order by versions_start_scn desc;
STARTSCN OPS EMPNO ENAME SAL
——————————————————————
751564 D 8000 HARRY 2500
751564 D 7902 FORD 3000
751564 D 7900 JAMES 950
751564 D 7876 ADAMS 1100
751564 D 7844 TURNER 1500
751564 D 7839 KING 3000
751564 D 7369 SMITH 800
751564 D 7782 CLARK 2450
751564 D 7698 BLAKE 2850
751564 D 7654 MARTIN 1250
751564 D 7566 JONES 2975
STARTSCN OPS EMPNO ENAME SAL
——————————————————————
751564 D 7521 WARD 1250
751564 D 7499 ALLEN 1600
751564 D 7788 SCOTT 3000
notes : versions_startscn-1 = untuk melihat scn pada saat sebelum melakukan delete pada table emp
