Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.1.5: exp yields "OR

Re: Oracle 8.1.5: exp yields "OR

From: André Hartmann <andrehartmann_at_hotmail.com>
Date: Mon, 4 Mar 2002 17:33:41 +0100
Message-ID: <a607l6$5bq$1@crusher.de.colt.net>


Hi,

  I had catexp.sql run as SYS... it is not fixed. Same error. catexp.sql passed without errors/warnings. Do I have to restart the instance ????

André
:(

"Ganesh Raja" <ganesh_at_gtfs-gulf.com> schrieb im Newsbeitrag news:a8aed4.0203040622.317f5bc4_at_posting.google.com... > "Andr?Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:<a5vb2v$kau$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:\>

>
> Run Catexp.sql Again. The problem will get solved.
>
> HTH
>
> Regards,
> Ganesh R
Received on Mon Mar 04 2002 - 10:33:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US