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)

 --最后通过这个解决