flashback drop(10g)

利用闪回恢复drop table数据

1. 查看回收站是否开启
SQL> show parameter recycle
NAME                                    TYPE        VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_recycle                 string
db_recycle_cache_size               big integer             0
recyclebin                          string                 on

2.禁用/启动该功能：
SQL> alter system set recyclebin=off;
SQL> alter system set recyclebin=on;
SQL> alter session set recyclebin=off;
SQL> alter session set recyclebin=on;

3.删除表
SQL> select * from A;
        ID
        ----------
         1
         2
         3
SQL> drop table A;

4.查看recyclebin中对象：
SQL> select original_name,object_name from recyclebin;
ORIGINAL_NAME                    OBJECT_NAME
-------------------------------- ------------------------------
A                                BIN$RWXQQcTPRde0ws4h9ewJcg==$0

5.查看recyblebin对象里的内容：
SQL> select * from "BIN$RWXQQcTPRde0ws4h9ewJcg==$0";
        ID
       ----------
         1
         2
         3
6.闪回操作
SQL> flashback table a to before drop;
闪回完成。