Re: 10g mystery table

On Sun, 14 Mar 2004 16:59:31 GMT, Paul Murphy <pmurphy3_at_twcny.rr.com> wrote:

>Red Hat Enterprise ES Ver3
>Oracle 10.1.0
>
>I installed everything this weekend and it works great. I love the new
>web based OEM. I had a bit of weirdness happen when I did a single table
>import. I truncated the table instead of dropping it, and since I had
>ignore=n, it complained that it couldn't create the table because it
>already exists. So, I dropped the table and ran the import successfully.
>Now for the weird part. I have an extra table:
>
>TNAME TABTYPE CLUSTERID
>------------------------------ ------- ----------
>BIN$1Zn7Fhh82z7gMDsYwIg84Q==$0 TABLE
>
>This table shows up in SQL*Plus, but not in OEM. I can't desc, drop or
>truncate it, I get an illegal name error. Have any of you seen something
>like this before?

 Look up 'recycle bin'. New 10g feature.

-- 
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>