query tables in the recyclebin

From: Roger Xu <wellmetus@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Sun, 2 Aug 2009 00:38:34 -0500

Dear all,

How come I cannot query the table in the 10g recyclebin via the naming
conversion in page 98 of Mr. Freeman's New Features book? See below and
thank you in advance. - Roger Xu


SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL> select * from xyz;

         N
----------
         1
       999

SQL> select OBJECT_ID from user_objects where OBJECT_NAME = 'XYZ';

 OBJECT_ID
----------
     61981

SQL> drop table xyz;

Table dropped.

SQL> select * from xyz;
select * from xyz
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select OBJECT_NAME, ORIGINAL_NAME from user_recyclebin;

OBJECT_NAME                    ORIGINAL_NAME
------------------------------ --------------------------------
BIN$cCK1wqmazEngQAB/AQBnOg==$0 XYZ

SQL> select * from "BIN$cCK1wqmazEngQAB/AQBnOg==$0";

         N
----------
         1
       999

SQL> select * from rb$$61981$table$0;
select * from rb$$61981$table$0
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

query tables in the recyclebin

Other related posts: