平凡的幸福(備站）

建立測試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