--查看回收站中表
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin;
--恢复表方法一
flashback table test_drop to before drop;
--恢复表方法二
flashback table "BIN$b+YppO1RS59K0uKo0BfudC==$0" to before drop;
注:必须9i或10g以上版本支持,flashback无法恢复全文索引