Hi

When I run an export it displays the following error in the log


************************
Connected to: Oracle8i Release 8.1.7.4.0 - Production
JServer Release 8.1.7.4.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table PERSON 1063913 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
. . exporting table CUSTUSAGE 1026906 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table CUSTINFO 1034798 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
. . exporting table UNAMES_TRAN 2282836 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table RENEWHISTORY 180117 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
. . exporting table RENEWBACKUP 617254 rows exported
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed
. . exporting table NASLOCATION 198 rows exported
EXP-00008: ORACLE error 904 encountered
ORA-00904: invalid column name
. . exporting table RENEWALREQUEST 197015 rows exported
EXP-00003: no storage definition found for segment(13, 116233)
. . exporting table ORDERDESPATCH 178788 rows exported
Export terminated successfully with warnings.

*********************************

but the table structure is OK
SQL> desc CUSTINFO
Name Null? Type
----------------------------------------- -------- ----------------------------
CUSTID NOT NULL NUMBER(32)
LOGINNAME NOT NULL VARCHAR2(32)
PRODCODE VARCHAR2(8)
SERVICEEND DATE
REMINDFLG DATE
EXPFLG VARCHAR2(2)
SUSPENDDT DATE



Why does it display the error Invalid column name and no statement parsed.

Oracle 8.1.7 on Sun OS

Thanks