Home » RDBMS Server » Server Administration » Un necessary tables present (oracle 10.2.0 enterprise version)
Un necessary tables present [message #539918] Thu, 19 January 2012 06:19 Go to next message
ravi_1967
Messages: 5
Registered: March 2010
Location: Mumbai
Junior Member
I was running oracle 10.2.0 enterprise version on my windows xp and maintaining the data around 10MB, suddenly i found 3nos of aditional table like 'BIN%'.

i have allocate 150MB tablespace and 50 MB temporary tablespace.

Please provide the solution how can drop the 'BIN%' tables and also suggest me if miss haldling configuration level fault.
Re: Un necessary tables present [message #539919 is a reply to message #539918] Thu, 19 January 2012 06:21 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
These tables are in recyclebin (Google!); purge them if you don't need them.

SQL> select * from tab where tname like 'BIN%';

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
BIN$0Ly1t0XRSKqt4EEdAoFeng==$0 TABLE
BIN$Mrc63hPKR760/4nZbU0oBA==$0 TABLE
BIN$T9vE4GqBTx6CBKNbtTojFA==$0 TABLE
BIN$TzQJpcN7TcSE+e9r5GGa+A==$0 TABLE
BIN$ztJliaQnREWQFtTwaXhf9w==$0 TABLE

SQL> purge recyclebin;

Recyclebin purged.

SQL> select * from tab where tname like 'BIN%';

no rows selected

SQL>
Re: Un necessary tables present [message #539928 is a reply to message #539918] Thu, 19 January 2012 07:03 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
See PURGE statement and related links inside.

Regards
Michel
Previous Topic: Oracle Reorganisation problem
Next Topic: CPU patch issue
Goto Forum:
  


Current Time: Fri Nov 29 04:36:47 CST 2024