1.找到删除的表名称

select object_name,
       original_name,
       partition_name,
       type,
       ts_name,
       createtime,
       droptime
  from recyclebin b
 where b.type = 'TABLE' AND B.original_name='表名称';

2.

flashback table "BIN$27cQBND/2ATgQAB/AQBv+A==$0" to before drop;