Re: Oracle 8.1.5: exp yields "ORA-00904: invalid column name"

André,
this could be caused by having a synonym DBMS_JAVA without the corresponging package. If you don't need Java enabled in your database, remove the synonym DBMS_JAVA or run rmjvm.sql as SYS to remove it.

Regards,
Andre van Winssen

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:a5vd6s$lc4$1_at_crusher.de.colt.net...
> Hi,
>
> when I export from my Oracle 8.1.5 Server on WinNT 4.0, I get the
> following message:
>
> . exporting synonyms
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-00000: Export terminated unsuccessfully
>
> .. why is this and how to mend ???? Please help, this is causing delay
in
> a project :( :(
>
> Below there is the full export dump. Thanks,
>
> André
> :O
>
>
>
>
> Export: Release 8.1.5.0.0 - Production on Mon Mar 4 09:18:02 2002
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>
> Connected to: Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
> With the Java option
> PL/SQL Release 8.1.5.0.0 - Production
> Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
> set
>
> About to export specified users ...
> . exporting pre-schema procedural objects and actions
> . exporting foreign function library names for user INTRANET
> . exporting object type definitions for user INTRANET
> About to export INTRANET's objects ...
> . exporting database links
> . exporting sequence numbers
> . exporting cluster definitions
> . about to export INTRANET's tables via Conventional Path ...
> . . exporting table ABC 2 rows
exported
> . . exporting table CAREERITEM 151 rows
exported
> . . exporting table CC 2 rows
exported
> . . exporting table MAHATRECHT 102 rows
exported
> . . exporting table MAHATRECHTINSUSY 63 rows
exported
> . . exporting table MITARBEITER 83 rows
exported
> . . exporting table PACE_SESSION 2 rows
exported
> . . exporting table RECHT 7 rows
exported
> . . exporting table SUSY 505 rows
exported
> . . exporting table SUSYDIFF 48 rows
exported
> . . exporting table TEMPLATE 77 rows
exported
> . . exporting table TESTBLOB 1 rows
exported
> . . exporting table URLAUB 11 rows
exported
> . . exporting table URLAUBSSTATUS 1 rows
exported
> . . exporting table VARIABLE 22 rows
exported
> . . exporting table VARIABLEINTEMPLATE 15 rows
exported
> . . exporting table VARIABLEOPTION 39 rows
exported
> . exporting synonyms
> EXP-00008: ORACLE error 904 encountered
> ORA-00904: invalid column name
> EXP-00000: Export terminated unsuccessfully
>
> C:\>
>
>
>
>
>
>
Received on Tue Mar 05 2002 - 03:09:02 CST