Re: junk as table names

<leshanster_at_gmail.com> wrote in message news:1138477288.756143.284110_at_f14g2000cwb.googlegroups.com...
> 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?
>

you're seeing the 'recycle bin'

lookup of the DROP TABLE command and you'll see the PURGE option, which does an absolute drop, and then look up the PURGE command to see how to get rid of your 'junk' (recycle bin) tables -- which will cross-reference you to the FLASHBACK TABLE command.

++ mcs Received on Sat Jan 28 2006 - 13:51:55 CST