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 -> Error in export (ORA-00904: invalid column name)

Error in export (ORA-00904: invalid column name)

From: Eric DUCHET <eric.duchet_at_free.fr>
Date: Tue, 30 Nov 1999 15:09:56 GMT
Message-ID: <8NR04.3773$hZ5.17740906@nnrp1.proxad.net>


Hi,

When I execute the export command on my Database, i've got the error message

ORA-00904: invalid column name

What does it mean ?????

Here is the trace from my exp command

Thanx in advance

exp

Export: Release 7.3.4.0.0 - Production on Tue Nov 30 15:56:43 1999

Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

Username:

Connected to: Oracle7 Server Release 7.3.4.0.0 - Production With the distributed and parallel query options PL/SQL Release 2.3.4.0.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp >

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > 3

Export table data (sim/não): sim >

Compress extents (sim/não): sim >

Export done in WE8ISO8859P1 character set

About to export specified tables via Conventional Path ... Table to be exported: (RETURN to quit) > receptacletypes

. . exporting table                ITEMTYPES          4 rows exported
EXP-00008: ORACLE error 904 encountered ORA-00904: invalid column name
Table to be exported: (RETURN to quit) >
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
EXP-00222:

System error message 4
EXP-00000: Export terminated unsuccessfully Received on Tue Nov 30 1999 - 09:09:56 CST

Original text of this message

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