oracle flashback 闪回

1.对表启动闪回
alter table emp enable row movement;

2.查看闪回点
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')  TIME from dual;

3.查看原形数据
select count(*) from emp;

4.删除数据
delete from emp;

5.提交
commit;

6.闪回
flashback table emp to timestamp to_date('2017-01-19 14:13:09','yyyy-mm-dd hh24:mi:ss');

7.验证闪回结果
select count(*) from emp;