可能会遇到快照过旧的问题,我删除数据是在当天下午,查询的是当天上午的数据,在一天之内,解决快照过旧问题
select * from core.tb_flow_model as of timestamp to_timestamp('2019-03-14 10:53:22', 'yyyy-mm-dd hh24:mi:ss');
alter table core.tb_flow_model enable row movement
flashback table core.tb_flow_model to timestamp to_timestamp('2019-03-14 10:53:22','yyyy-mm-dd hh24:mi:ss')
alter table core.tb_flow_model disable row movement