Oracle 11g 查詢 recyclebin(回收箱)內表格的資料

建立測試Table
SQL> CREATE TABLE  TEST_CCC(  A  VARCHAR2(20 BYTE)) ;

Table created.

SQL> insert into test_ccc values ( 'aa');

1 row created.

insert into test_ccc values ( 'bb');

1 row created.

SQL> commit;

Commit complete.

SQL> select count(1) from test_ccc;

  COUNT(1)
----------
         2

SQL> drop table test_ccc ;

Table dropped.

SQL> select object_name,ORIGINAL_NAME,OPERATION from user_recyclebin;

OBJECT_NAME                    ORIGINAL_NAME          OPERATION
------------------------------ ---------------------- ---------
BIN$+65JcJ7AGHPgRAAUT/lsSQ==$0 TEST_CCC               DROP

以object_name為表格名稱就可以查詢放在recyclebin內的表格資料
SQL> select * from "BIN$+65JcJ7AGHPgRAAUT/lsSQ==$0";

A
--------------------
aa
bb

Oracle Data Gurad Archive Gap