10g mystery table

From: Paul Murphy <pmurphy3_at_twcny.rr.com>
Date: Sun, 14 Mar 2004 16:59:31 GMT
Message-ID: <Tb05c.5502$Oo5.2483@twister.nyroc.rr.com>

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 Received on Sun Mar 14 2004 - 10:59:31 CST