New TNAMEs [message #460343] |
Thu, 10 June 2010 11:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #460346 is a reply to message #460344] |
Thu, 10 June 2010 12:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|