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');