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

How to Restore deleted records in other table in oracle database 10g...

Hi All, i want to restore deleted records of a particular table in other table suppose: i perform a query delete from emp where deptno =30; now i wont to restore deptno=30 records in other table, let say in emp1 table can any one let me know how to d

Convhow to erting MySQL database into oracle Database

Hi, how to import/convert MySQL database/tables into oracle database/table. i need SQL code or any import wizard technique. ThnxzPlease refer: http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.htmlRead other 2 answers

Dump : Table not found in oracle database

Hi, I am doing a program regarding analysis of tables belonging to archiving objects.In my program i am calling a RFC function module . 'DB02_ORA_TABLE_INDEX_ANALYSIS . But it is giving the dump for native sql statement . --- Oracle block size ------

List user tables in oracle 9i database

Hi, Im new bi to oracle database..., Will anyone provide me the command to list the user tables in oracle 9i database.??. im using linux redhat 4.0... and oracle 9i database.... thanks, vasanth....user12864080 wrote: Hi, Im new bi to oracle database.

Internal Behaviour of Truncate Table Command in Oracle Database

Hi, Can anyone let me know the internal behaviour of Truncate Table Command in Oracle Database? Thanks, Harshad.Hi Tuhinshoor, I know the functioning of Truncate Command. But, I needed to know whether it drops the table before recreating it, maintain

TimeZone.getDefault().getID() does not exist in your Oracle database table V$TIMEZONE_NAMES???

Hi Everyone, My Jdev version is 11.1.2.3.0. I have developed many ADF applications in this version itself by setting time zone as -Duser.timezone="+05:30" and all were running fine. But Jdeveloper got crashed so i reinstalled the same version bu

Oracle Database all table structure

Hi I want donwload Oracle Database all table structure , any one please explain where i can download the structure in text format regardsSQL> desc user_tables; Name Null? Type TABLE_NAME NOT NULL VARCHAR2(30) TABLESPACE_NAME VARCHAR2(30) CLUSTER_NAME

GTC Error While Provisioning to Oracle Database Tables

I'm trying to setup GTC connector to provisioning/reconcile users into database tables, but during the provisionig gtc fails. check the lines above to see the error ERROR,07 Nov 2010 20:18:38,383,[OIMCP.DATC],Class/Method: DBProvisioningTransportProv

Can I define tables/views of another oracle database as data sources in DBI?

Hi! Assuming I created a dblink between an Oracle EBS database and another oracle database and I wish to create custom dashboards and reports in Oracle Daily Business Intelligence, will the tables/views from the another oracle database be allowed as

Uploading text file (TAB delimited) to Oracle database table

Hi, im creating a form that will upload a text file(TAB delimited) that will insert a data in a database table. How would i do this? And what trigger will i use in the upload button? Please help.. Thanks, Majichi majic, Check any of this site related

Can't access tables in other Oracle database schemas

Hi. We got our Oracle database admin to install APEX in our Oracle database. She created a login and schema for my Oracle database user so that I could work with APEX a little. Here's the information on the version of APEX we have installed: Database

Synonym required to query custom tables from Oracle Apps database

When creating an Answers report that queries from a table owned by a custom schema (not APPS), I cannot query the table and get error. Once I add a Synonym for APPS on this table, then OBIEE works normally. Since OBIEE is logging in as the APPS user,

Large Oracle database breaks Oracle Connector?

Our Problem: Oracle connector is unable to retrieve the schema for column selection (uninstrumented/instrumented columns) in the connector setup due to timeout on a database with a large amount of schema. Has anyone else had a similar experience? We

Query to find the biggest table in the database..!!!

Hello everybody, i have more than 600 tables in the database i need to find the biggest table in the database and want to order it in descending pattern.. Is there any query for this task... Rgds Harsh.What version of Oracle? Do you use the CBO or th

Empty CLOB field value from Oracle database using JDBC Sender

Hi All, I am selecting a CLOB field from Oracle database table using JDBC Sender adapter and getting error "NullPointerException" Seen SAP note 1283089 but its not applicable for my support pack PI 7.0 SP 12 and client dont want to upgrdate SP 1

NCHAR issue with oracle database using JDBC adapter

Hi, We have a requirement to develop an XI interface from FTP server(File adapter) to oracle database using JDBC adapter. In the oracle database table few fields are of type NCHAR/NVARCHAR. when we try to insert the character(A,B,c..) values into ora

How to insert into SQL server table form oracle forms

I created a form with oracle as my database. But there one trigger where I need to insert the data into a sql server table. Is this possible. If so can any help me out. Thanks in advance. AshaHi, You can insert into sql server database using the foll

Errors in the process of import the oracle database

The problem is this: I have a application (SKF @ptitude Analyst), uses oracle database in version 9i, 10g, 11g. My recomendations for working persons with the software, is that often make a backup the database (for this use the command"exp"). bu

Join between Oracle and non-Oracle Database

We are working at a project with the follow architecture: - 5 Databases (3 Oracle, 1 Sybase and 1 DB2); - Session Bean like Session Facade Pattern; - Entity Bean (BMP); - OC4J (Oracle Container for J2EE); The case is that we cannot make join between