Re: tables with names like BIN$+8U+85NvSla5kZXvWwSOhQ==$0

Jeff Kish wrote:
> Hi.
>
> I just installed oracle 10g, and found that for some reason a large
> number of strange tables have been created in my schema that I have
> not explicitly created; They have names such as:
> Hi.
>
> I just installed oracle 10g, and found that for some reason a large
> number of strange tables have been created in my schema that I have
> not explicitly created; They have names such as:
>
> BIN$+8U+85NvSla5kZXvWwSOhQ==$0
>
> Can someone tell me what I've done to deserve such tables in my
> schema?
>
> They don't appear when I run the same scripts in Oracle 9, so I
> figure it is some sort of option or something.
>
> Are they backup tables of some sort? (their column names are very similar to
> those of the tables I normally create).
>
> Thanks

The recyclebin is new to 10g.

You can find demos of it at http://www.psoug.org click on Morgan's Library
click on Recyclebin

Be aware that it is possible to SELECT data from a dropped table that has not been purged from the recyclebin.

SELECT *
FROM "BIN$+8U+85NvSla5kZXvWwSOhQ==$0";

works just fine. So if you really want to drop a table you must:

DROP TABLE <table_name> PURGE;

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