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>