Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Error in export (ORA-00904: invalid column name)
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 exportedEXP-00008: ORACLE error 904 encountered ORA-00904: invalid column name
EXP-00008: ORACLE error 904 encountered ORA-00904: invalid column name EXP-00222: