oracle误删误改数据的回闪

//复制40分钟前表的数据到新表

create table new_table_name as  select  * from old_table_name  as of timestamp (systimestamp - interval '40' minute );

//复制某一时间前的数据到新表

create table new_table_name  as select * from old_table_name as of timestamp to_timestamp(‘2015-07-27 09:00:00’,‘yyyy-mm-dd hh24:mi:ss’);