oracle 10 g 回收站相关

查看被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;