Tables left after DROP

[Whitterness]

I'm relatively new to SQL (am taking it for an IT class). We're using Oralce Developer Suite 10g (9.0.4.0.1) and SQL*Plus to do our coding.

I created tables and then dropped them. When I would put in

SELECT table_name
FROM user_tables;

I get a list of a bunch of tables with weird names that start with BIN$

I was wondering how to get rid of them. I tried searching for it online, but could only find things that says to use the PURGE commant, but SQL*Plus doesnt recognize that as a valid command..

Any help would be appreciated.
THanks.

 

[LKBrwnDBA]

That's the Recycle bin (like WinDoze). Any table you drop goes there so you can recover it.

To remove these, use the PURGE command.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[tridith]

Purge [Oracle SQL]

purge table name-of-table
purge index name-of-table
purge recyclebin
purge dba_recyclebin
purge tablespace name-of-tablespace
purge tablespace name-of-tablespaces user name-of-user

 

[Welshbird]

oR, if you are really sure when you drop the table that you won't want it back:

drop table my_table purge

and then it never makes it to the recycle bin.

You can also type

show recyclebin

to see the tables you dropped.

Sorry, you probably already know this - it's just very rare that I can actually answer a question in here rather than ask one!

Fee

The question should be [red]Is it worth trying to do?[/red] not [blue] Can it be done?[/blue]