query tables in the recyclebin

From: Roger Xu <wellmetus_at_gmail.com>
Date: Sun, 2 Aug 2009 00:38:34 -0500
Message-ID: <eb64345d0908012238r3690baeboe94e260a17c35df9_at_mail.gmail.com>

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>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Aug 02 2009 - 00:38:34 CDT