1、查询某张表在某个时间点的数据
select * from t_p_ao_vat_plan_deta as of timestamp to_timestamp(‘2018-05-14 21:20:00’,‘yyyy-mm-dd HH24:MI:SS’);
2、
alter table t_p_ao_vat_plan_deta enable row movement;
3、恢复数据
flashback table t_p_ao_vat_plan_deta to timestamp to_timestamp(‘2018-05-14 21:20:00’,‘yyyy-mm-dd HH24:MI:SS’);