Re: 10g mystery table

From: Paul Murphy <pmurphy3_at_twcny.rr.com>
Date: Sun, 14 Mar 2004 17:05:23 GMT
Message-ID: <nh05c.5503$Oo5.1378@twister.nyroc.rr.com>

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
>

I think I night have figured it out. I dropped another table and now I have two mystery tables. I think it's a flashback/undo type of feature where I can recover dropped objects up to a certain point in time.

Paul Murphy Received on Sun Mar 14 2004 - 11:05:23 CST