ORACLE数据库update/delete 语句提交后的 恢复

查出需要撤销SQL 的执行时间

SELECT last_load_time, sql_text
    FROM v$sql
   WHERE last_load_time IS NOT NULL
   and sql_text like '%,''15''%'
ORDER BY last_load_time DESC;

创建一个新表将上述语句执行之前的数据插入进去

create table tbl_research_recove
as
select * from  tbl_research
as of timestamp to_timestamp('2014-10-10/18:03:44','yyyy-mm-dd/hh24:mi:ss');

用比较工具找到相应的数据并恢复