oracle 误删除数据，回退表数据

select * from sh_gonghuo_renyuan as of timestamp to_timestamp('2017-11-17 16:00:00','yyyy-mm-dd hh24:mi:ss');  

--3、恢复删除且已提交的数据

alter table sh_gonghuo_renyuan enable row movement;

--flashback table sh_gonghuo_renyuan to timestamp to_timestamp('2017-11-17 16:00:00','yyyy-mm-dd hh24:mi:ss');
 flashback table sh_gonghuo_renyuan to timestamp (systimestamp-interval '30' minute)
 --最后通过这个解决

转载于:https://www.cnblogs.com/zrlhss/p/7852517.html