1.闪回到某个时间点前数据查询:
select * from student as of timestamp to_timestamp('2014-11-13 11:39:00','yyyy-mm-dd hh24:mi:ss');
2.将数据恢复到一个临时表
insert into student_tmp (select * from student as of timestamp to_timestamp('2014-11-13 11:39:00','yyyy-mm-dd hh24:mi:ss'));
3.将临时表数据插入正式表
insert into student (select * from student_tmp);
select * from student as of timestamp to_timestamp('2014-11-13 11:39:00','yyyy-mm-dd hh24:mi:ss');
2.将数据恢复到一个临时表
insert into student_tmp (select * from student as of timestamp to_timestamp('2014-11-13 11:39:00','yyyy-mm-dd hh24:mi:ss'));
3.将临时表数据插入正式表
insert into student (select * from student_tmp);