恢复drop掉的表

1.先查出drop信息

select * from recyclebin a where a.original_name = '表名'

2.恢复

flashback table "BIN$ezueuZPb4SXgU8R44IZnwg==$0" to before drop;

闪回数据

select * from 表名 as of timestamp to_timestamp('2018-03-03 14:00:00', 'yyyy-mm-dd hh24:mi:ss');

原文链接:https://miansen.wang/2018/11/23/2/