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

whats the table definition?

do any of the column names start with a number?

Eric DUCHET wrote in message <8NR04.3773$hZ5.17740906_at_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 - 10:22:50 CST