Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: 10g mystery table

Re: 10g mystery table

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 15 Mar 2004 10:00:00 -0000
Message-ID: <40557ea1$0$3304$ed9e5944@reading.news.pipex.net>


"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.

Correct, Arup Nanda has an article on just this on OTN.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Mon Mar 15 2004 - 04:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US