Garbage tables in oracle database

Advertisement
Hi,
Is there anyone can tell me whats wrong with my database. I dont know what is actually the problem is in my oracle scott database i got some garbage table name once i try to execute "select table_name from user_tables" command. Here is the output of that sql query.
SQL> select table_name from us
TABLE_NAME
CATEGORY
CMSUSER
BIN$z0xX8EzoTImZ+QowtHKAXQ==$0
BIN$MeMzxCSqR7elgZJtlErZCQ==$0
BIN$pVQJDfURR2CcvD39ovSQjg==$0
BIN$VNlU74WURPeWd/ttf6wmLQ==$0
BIN$DWgeccctTCWdWJiQSp98bw==$0
BIN$kjgqXmwVRru/9klO+AGhEQ==$0
BIN$5oUGRsk2SACYN84B2KcxVA==$0
BIN$YmySQWcrSI2MsDp5J43AaA==$0
T_COMPBOOKING
TABLE_NAME
T_COMPUTER
BIN$2fIY1imJRi2r/1ZfZbXKnA==$0
BIN$wn2OVNNiQcKP8nV7xHRqrQ==$0
BIN$xgjzcC90QZmGOJw6mQK78w==$0
BIN$AEAc1N3gSzqx8Of9kuHTlw==$0
BIN$ZqieT3+3RbSWNiFfTVmGBw==$0
BIN$THw8LJJBSkCasju6e8WC0g==$0
BIN$OHL4q1r/SBmf6LPIxCmrvA==$0
BIN$L+GFDZvMTXS+FI53z/6JOw==$0
BIN$M8Q4CYgNSXu9cbU3MVO0Ww==$0
BIN$tRVUHjNFRsCpzd4w4jUOtA==$0
TABLE_NAME
BIN$eCDMIZraQ4GF6BfO4L4o4Q==$0
BIN$w3BHAefyRsqDyUrZWI8pOg==$0
BIN$gVlUKhrCROme/elxLwruqw==$0
BIN$lb/0xLyZSuiqAtrxX+2n6A==$0
BIN$Gz8OvMDXTrC/ZLDM93nSUg==$0
BIN$cULMUXV8RJGiXnh2Ml+WYA==$0
BIN$Dqclit06RIqfrIRwb8enzA==$0
BIN$SiJFG3FlSZmCK+OJMGVQjQ==$0
BIN$nYXut5odTBSaHIK2Uk2ZEg==$0
ORDERDETAILS
ITEMS
TABLE_NAME
ORDERS
SUPPLIERS
CUSTOMERS
EMPLOYEES
SALGRADE
BONUS
EMP
DEPT
41 rows selected.
what is those bin bla bla i got no idea.
Im useing oracle10g home my OS is winxp and my paths are
C:\Documents and Settings\Hasnain>path
PATH=C:\PROGRA~1\RATIONAL\RATION~1\NUTCROOT\bin;C:\PROGRA~1\RATIONAL\RATION~1\NU
TCROOT\bin\x11;C:\PROGRA~1\RATIONAL\RATION~1\NUTCROOT\mksnt;E:\oracle\product\10
.1.0\Db_1\bin;E:\oracle\product\10.1.0\Db_1\jre\1.4.2\bin\client;E:\oracle\produ
ct\10.1.0\Db_1\jre\1.4.2\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\
Wbem;C:\PROGRA~1\ULTRAE~1;C:\Program Files\SecureCRT;C:\j2sdk1.4.2_05\bin;C:\mys
ql\bin;C:\Program Files\Rational\common;C:\Program Files\Rational\ClearQuest;C:\
Program Files\Rational\Rose\TopLink\;C:\Program Files\Rational\Rational Test;c:\
matlab6p5\bin\win32;C:\MATLAB6p5\bin\win32;c\php;C:\Program Files\SSH Communicat
ions Security\SSH Secure Shell
Please help me i dont know whats wrong with it.
Thanks
Hasnain
Advertisement

Replay

How do you define an "unnecessary bin"?
When you are dropping a table, you can specify the PURGE clause to bypass the recycle bin. You can also purge objects from the recycle bin
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/tables.htm#sthref2018
Oracle also maintains a mapping of the recycle bin name to the original table name in USER_ or DBA_RECYCLEBIN
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/tables.htm#i1010757
Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC