1:查询ID,根据时间
select timestamp_to_scn(to_timestamp('2012-04-11 17:00:00','YYYY-MM-DD HH24:MI:SS')) id from dual
2:根据ID找回数据
select * from 表名
AS OF SCN id
insert into xt_yh select * from 表名
AS OF SCN id
1:查询ID,根据时间
select timestamp_to_scn(to_timestamp('2012-04-11 17:00:00','YYYY-MM-DD HH24:MI:SS')) id from dual
2:根据ID找回数据
select * from 表名
AS OF SCN id
insert into xt_yh select * from 表名
AS OF SCN id