flashback drop(10g)

利用闪回恢复drop table数据

1. 查看回收站是否开启SQL> show parameter recycleNAME                                    TYPE        VALUE------------------------------------ ----------- ------------------------------buffer_pool_recycle                 stringdb_recycle_cache_size               big integer             0recyclebin                          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         3SQL> 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         36.闪回操作SQL> flashback table a to before drop;闪回完成。