恢复oracle中用pl sql误删除drop掉的表

查看回收站中表

select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;

 

恢复表

SQL>flashback table test_drop to before drop;
-- 或
SQL>flashback table "BIN$b+XkkO1RS5K10uKo9BfmuA==$0" to before drop;