Re: exp error

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 09 Jun 2001 12:02:02 +0100
Message-ID: <3B22022A.1AC6335C@yahoo.com>

Craig Kelley wrote:

> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ti1t1ts2hpdi65_at_beta-news.demon.nl>...

> > "Craig Kelley" <ink_at_inconnu.isu.edu> wrote in message
> > news:ti1rbp6usmq78d_at_corp.supernews.com...
> > > Hello Oracles;
> > >
> > > I've been running Oracle for some years now, but this latest error has me
> > > stumped. In running exp on a fairly large database (about 80gb):
> > >
> > > [snip]
> > >
> > > . . exporting table THERAXLATION 682 rows
 exported
> > > . . exporting table TYPEXLATION 15 rows
 exported
> > > . . exporting table VAUGHN1 41 rows
 exported
> > > . exporting synonyms
> > > EXP-00008: ORACLE error 904 encountered
> > > ORA-00904: invalid column name
> > > EXP-00222:
> > > System error message 2
> > > EXP-00000: Export terminated unsuccessfully
> > >
> > > None of the error help files are of any 'help' (they usually are,
> > > though). Does anyone else have an idea as to what is going on here?
> > > Thanks a bunch,
> > >
> > > Craig Kelley -

> >

> > You upgraded and forgot to run catexp.sql

>
> No, we haven't upgraded, but thanks for the tip.
>
> For usenet archives: Someone sent an e-mail with the solution; we
> had to drop the public synonm 'DBMS_JAVA'.  This is supposedly a
> bug in Oracle 8.1.5 (?) and after doing that the export worked
> just fine.
>

> > Other than that you can trace the export session, the faulty statement will
> > be listed, together with err=904

>
> Thankfully I didn't have to do that. :)

If you have a search on Metalink, I've lost count of the number of different reasons for getting 904's with an export... You think Oracle would get that right eventually...

Cheers
Connor

--
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Sat Jun 09 2001 - 06:02:02 CDT