1、查询指定时间点的数据
select * from xxx as of timestamp to_timestamp('2019-08-15 15:29:00','yyyy-mm-dd hh24:mi:ss');
2、将已删除的数据恢复到数据库
insert into xxx select * from xxx as of timestamp to_timestamp('2019-08-15 15:29:00','yyyy-mm-dd hh24:mi:ss');
3、将数据恢复到指定时间
flashback table xxx to timestamp to_timestamp('2013-05-29 15:29:00','yyyy-mm-dd hh24:mi:ss');
4、如果使用drop删除了表
FLASHBACK TABLE xxx TO BEFORE DROP;