Re: exp error

"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. :) Received on Fri Jun 08 2001 - 15:55:39 CDT