Re: how could i delete the table like BIN$f6GBGK31SZyUKsciPQ56mg==$0

purge recyclebin;

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005






"tri dhungana via DBMonster.com" <forum_at_nospam.DBMonster.com> wrote in 
message news:25f247b55678488da21cb16aae560ead_at_DBMonster.com...


>i have delete some table using

>

> drop table tablename

>

> but when i use select statement it shows like following

>

>

> SQL> select * from tab;

>

> TNAME                          TABTYPE  CLUSTERID

> ------------------------------ ------- ----------

> BIN$iQDS/10CRYiOscUfsisYIA==$0 TABLE

> LOGIN                          TABLE

> MENUITEM                       TABLE

> VCODE                          TABLE

> BIN$vSCjbu/jSy2POsU1Kx1SyA==$0 TABLE

> BCODE                          TABLE

> HEADERFILE                     TABLE

> DCODE                          TABLE

> ACHEAD                         TABLE

> BIN$4RvnXD6PS+yyNIjZgcg8DQ==$0 TABLE

> BIN$sp88nFafSIulttcKAtH93A==$0 TABLE

>

> now how could i permanently delete this table like BIN

> $sp88nFafSIulttcKAtH93A==$0

>

> -- 

> Message posted via DBMonster.com

> http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200505/1