Home » Other » General » New TNAMEs (Oracle 10g,10.2.0.3.0, Windows)
New TNAMEs [message #460343] Thu, 10 June 2010 11:59 Go to next message
lakshmis
Messages: 102
Registered: November 2008
Location: India
Senior Member
Hi all,
I have recently installed Oracle 10g in my laptop.
When I issue SELECT * FROM tab, I get a list of tables which starts with 'BIN$'.
Can anyone let me know what are they? and how to get rid of them?

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> SHOW USER;
USER is "SCOTT"
SQL> SELECT * FROM tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BIN$3lGbNN7tQXexkDQJDC327A==$0 TABLE
BIN$VxuLdVFmST67ojcCJl7qNg==$0 TABLE
TEST                           TABLE
EMPLOYEE                       TABLE
BIN$czqdZbeHSfe1j+TyHxKVNg==$0 TABLE
BIN$AZoAsgsBRVeSQDNdG917rw==$0 TABLE
BIN$6t2QG/OSTyaAZULjnxz9EA==$0 TABLE
BIN$JhT9IaOSRl2cqEA5H8pXoQ==$0 TABLE
BIN$7SoqqDdcQCypI5B3arYi6A==$0 TABLE
EMP_VIEW                       VIEW
BIN$gtCrwk0NRbu92qYjHFcT5A==$0 TABLE

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BIN$ts2AkgjdTvuv2rr8qAq+iA==$0 TABLE
BIN$Naer6IcBQGuloqaIxtdgFg==$0 TABLE
.
.
.
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BIN$U34Bz4emTkOfEbdr491qLA==$0 TABLE

100 rows selected.


Regards,
Lakshmi
Re: New TNAMEs [message #460344 is a reply to message #460343] Thu, 10 June 2010 12:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Administrator's Guide
Chapter 15 Managing Tables
Section Using Flashback Drop and Managing the Recycle Bin
Paragraph What Is the Recycle Bin?

Regards
Michel

Re: New TNAMEs [message #460345 is a reply to message #460344] Thu, 10 June 2010 12:22 Go to previous messageGo to next message
lakshmis
Messages: 102
Registered: November 2008
Location: India
Senior Member
Hi,
Thanks for the Link. Problem solved.
Regards,
Lakshmi.
Re: New TNAMEs [message #460346 is a reply to message #460344] Thu, 10 June 2010 12:30 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Perhaps this is another reason why the doc's have said for the last few releases "TAB is included for compatibility. Oracle recommends that you do not use this view." I remember that at one time, the docs said that it was only there for compatibility with release 5!
Re: New TNAMEs [message #460348 is a reply to message #460346] Thu, 10 June 2010 12:33 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is correct but many softwares that were created in these versions still use it (and COL...) and so newbies that work on these softwares (as developers or end users) use the same...

Regards
Michel

[Updated on: Thu, 10 June 2010 12:34]

Report message to a moderator

Previous Topic: Oracle's unlimited license agreements
Next Topic: Result Cache in Oracle 11g
Goto Forum:
  


Current Time: Thu Mar 28 15:36:24 CDT 2024