Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deezy
Starting Member
2 Posts |
 Posted - 2012-03-03 : 20:59:04
|
Say I create a table, using:create table test(test char(1)); I then drop the table with:drop table test; I then look at the tables using select * from tab; and this is what appears:quote:
TNAME TABTYPE CLUSTERID------------------------------ ------- ----------BIN$umLG0MHe+ADgQGCDZDF/6w==$0 TABLE
The "BIN$umLG0MHe+ADgQGCDZDF/6w==$0" part is where the table test used to be. I don't understand why this segment is left behind after dropping a table. It's not that huge of a problem, but I'm planning on creating and deleting a lot of tables and I don't want all the extra clutter from tables that have been deleted. Is there a way to completely clear it out? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2012-03-04 : 03:35:07
|
| TNAME TABTYPE CLUSTERID is from Oracle I think.Perhaps the "Undo" facility for dropped tables? |
 |
|
|
deezy
Starting Member
2 Posts |
Posted - 2012-03-04 : 15:03:51
|
Yes, it's Oracle. SQL*Plus: Release 11.1.0.6.0 - Production on Sun Mar 4 15:46:48 2012I just found out that BIN is for recycle bin.purge recyclebin; clears it! |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-04 : 18:16:36
|
| For future Oracle questions, may I suggest an Oracle forum? This site is specifically for Microsoft SQL Server.http://www.dbforums.com/oracle/--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Drop table not completely deleting table?