查看被drop的表
SELECT * FROM user_recyclebin WHERE original_name='table_name';
还原被drop的表
FLASHBACK TABLE table_name TO BEFORE DROP;
flashback table table_name to before drop rename to table_new_name;
清空回收站
purge recyclebin;
SELECT * FROM user_recyclebin WHERE original_name='table_name';
还原被drop的表
FLASHBACK TABLE table_name TO BEFORE DROP;
flashback table table_name to before drop rename to table_new_name;
清空回收站
purge recyclebin;