delete误删除恢复

-----delete误删除恢复

---1.查询恢复哪个时间点的数据
select count(1) from t_imp_zhujian as of timestamp to_timestamp('2018-06-12 15:20:15','yyyy-mm-dd hh24:mi:ss');

---2.启用行移动功能
alter table t_imp_zhujian enable row movement;

----3.再恢复那个时间点的数据
flashback table t_imp_zhujian to timestamp to_timestamp('2018-06-12 15:20:15','yyyy-mm-dd hh24:mi:ss');

转载于:https://www.cnblogs.com/jiangqingfeng/p/9173345.html