Re: 10g mystery table

Paul Murphy 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?
>
> Thanks, Paul Murphy

The entire methodology for 10g is explained at: http://www.psoug.org/reference/tables.html -- new with 10g http://www.psoug.org/reference/recyclebin.html

You can remove them with:
PURGE recyclebin;

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)