闪回数据??1：查询ID，根据时间? select timestamp_to_scn(to_timestamp(2012-04-11 17:00:00,YYYY-MM-DD
闪回数据
?
?
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
?