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

Jeff Kish wrote:
> 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

It would be difficult to remember from an earlier release of Oracle a feature which did not exist before 10g. It would also be fairly easy and straightforward to search the newsgroup BEFORE asking such questions, as this same inquiry has been answered more than once.

Possibly next time a newsgroup search will be in order ...

David Fitzjarrell Received on Thu Jun 02 2005 - 17:57:11 CDT