恢复Oracle中误删除drop掉的表sql

--查询被DROP的表
SELECT OBJECT_NAME,ORIGINAL_NAME,PARTITION_NAME,TYPE,TS_NAME,CREATETIME,DROPTIME FROM RECYCLEBIN ORDER BY DROPTIME DESC;
--根据表名恢复被DROP的表
FLASHBACK TABLE TABLE_NAME TO BEFORE DROP;