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

On Thu, 02 Jun 2005 22:22:03 +0100, Andy Hassall <andy_at_andyh.co.uk> wrote:

>On Thu, 02 Jun 2005 17:15:50 -0400, Jeff Kish <jeff.kish_at_mro.com> wrote:
>
>>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).
>
>
>http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/tables.htm#ADMIN01511
Thanks Andy.

I see quite clearly now. The recyclebin.. I don't remember it from before.. like in oracle 9i.

regards Received on Thu Jun 02 2005 - 17:24:27 CDT