oracle 闪回表

 

先设置表可移动

alter table account_of_check_file enable row movement

 

然后闪回到 '2011-09-07 22:05:00' 这一刻的数据

flashback table account_of_check_file to TIMESTAMP to_timestamp('2011-09-07 22:05:00','yyyy-mm-dd hh24:mi:ss');