--启用回行
alter table biz_user enable row movement;
--查看某个时间点表数据
select * from biz_user as of timestamp to_timestamp('2013-07-29 14:48:00','yyyy-mm-dd hh24:mi:ss')
--恢复表到某个时间点
flashback table biz_user to timestamp to_timestamp('2013-07-29 14:40:00','yyyy-mm-dd hh24:mi:ss');
---查看某个时间点的数据时还可以加条件:
如:select * from biz_user as of timestamp to_timestamp('2013-07-29 14:50:00','yyyy-mm-dd hh24:mi:ss') where username like '%王二小%';