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

tri dhungana via DBMonster.com wrote:
> 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

Follow Jonathan Lewis' advice but also go to: http://www.psoug.org
click on Purge Recyclebin
and
click on Table Flashback
and
click on Tables

Be aware that a dropped table, not dropped with the PURGE keyword can be queried or flashed back at any time unless overwritten.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)