oracle数据误操作flashback

发布于 2021-01-26  85 次阅读



select t.first_load_time, t.*
  from v$sqlarea t
 where rownum < 20
   and sql_text like '%set del_flag%'
 order by t.first_load_time desc; --模糊搜索误执行的sql

select *
  from TEST_TABLE --你操作的那张表
       as of timestamp to_timestamp('2021-01-11 16:33:42', 'yyyy-mm-dd hh24:mi:ss');

create table TEST_TABLE_TMP as
  select *
    from TEST_TABLE --你操作的那张表
         as of timestamp to_timestamp('2021-01-11 16:33:42', 'yyyy-mm-dd hh24:mi:ss');

 


啦啦啦!