flashback命令

1. 查看表上的时段上的各个版本

 select versions_xid,a1 from ttt
  versions between timestamp to_timestamp('2007-11-14 08:04:25','yyyy-mm-dd hh24:mi:ss')
  and to_timestamp('2007-11-14 08:05:00','yyyy-mm-dd hh24:mi:ss')

 

2. 寻找过去时间点上表的镜像

 select * from ttt as of timestamp to_timestamp('2007-11-14 07:54:55','yyyy-mm-dd hh24:mi:ss');

 

3. drop表后，恢复表

flashback table ttt to before drop rename to tttt;