Re: Oracle 8.1.5: exp yields "OR

André Hartmann wrote:
>
> 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:\>

There are several bugs which cause this error - try setting STATISTICS=NONE. Probably a better idea would be to upgrade to (say) 8.1.6.3 or 8.1.7.3

hth
connor

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

http://www.oracledba.co.uk

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