--设置时间格式：
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
--查询变更的记录
select * from t_information_check as of timestamp to_timestamp('2011-04-28 17:35:00','yyyy-mm-dd hh24:mi:ss');
--将变更的记录保存到新建表中
create table t_information_check_20110428 as
select * from t_information_check as of timestamp to_timestamp('2011-04-28 17:35:00','yyyy-mm-dd hh24:mi:ss');
--允许表移动
alter table t_information_check enable row movement;
--闪回表
flashback table t_information_check to timestamp to_timestamp('2012-02-16 17:53:00','yyyy-mm-dd hh24:mi:ss');
