Re: exp error

"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

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

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Jun 08 2001 - 10:52:32 CDT