Re: 10g mystery table

"Paul Murphy" <pmurphy3_at_twcny.rr.com> wrote in message news:nh05c.5503$Oo5.1378_at_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
>

drop table xx purge ( i think) Received on Sun Mar 14 2004 - 11:33:14 CST