Re: junk as table names

leshanster_at_gmail.com wrote:
> Hey guys, sorry to bother you again, but I am coming into a problem
> that I don't know how to fix.
>
> I create a table by saying:
>
> create table a (b number);
>
> and a table is created and I can view the table by using:
>
> select table_name from user_tables;
>
> then I drop the table by using:
>
> drop table a;
>
> commit;
>
> then when I view the list of tables I have, I get:
> TABLE_NAME
> -----------------------------------------
> BIN$XZFPbjldRmm5fzdo3pJpnA==$0
>
> for every table I create and drop I get this...
>
> any ideas on how to solve this problem?

This has been asked and answered numerous times:

This is a function of the RECYCLEBIN in Oracle 10g; simply:

SQL> purge recyclebin;

and they magically disappear.

David Fitzjarrell Received on Sat Jan 28 2006 - 13:52:00 CST