FAQ
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>

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 2, '09 at 5:38a
activeAug 2, '09 at 5:38a
posts1
users1
websiteoracle.com

1 user in discussion

Roger Xu: 1 post

People

Translate

site design / logo © 2022 Grokbase