create table tunregister_20121105bak nologging as
SELECT * FROM tunregister AS OF TIMESTAMP SYSDATE-20/24 where +条件 ;
恢复四个小时前的数据
第二种方式
alter table tsys_trans enable row movement;
Flashback table tsys_trans to timestamp to_timestamp('2013-01-26 09:00:05','yyyy-mm-dd hh24:mi:ss');