1, first check whether the field name or the table name error, if not, continue;
2, the following analysis data from: http://blog.itpub.net/23135684/viewspace-680615/
Exp Export always appears ORA-00904: "Poltyp": Invalid identifier may have two reasons:
1). Server and client one is X86bit, one is the X86_64bit installer.
2). The client and server side versions are incompatible.
Here are some of the tests done:
> situation 1:
The client for Windows X86_64bit 11.2.0.1 exports the Oracle Database for Windows x86 10.2.0.3.
Unable to perform export, received ORA-00904 error.
EXP-00008: Encountering ORACLE error 904
ORA-00904: "Poltyp": Invalid identifier
EXP-00000: Export termination failed
> Situation 2:
The Linux x86_64bit 10.2.0.5 client exports the Oracle Database for Windows x86 10.2.0.3.
Unable to perform export, received ORA-00904 error.
Exp-00008:oracle Error 904 encountered
ORA-00904: "Poltyp": Invalid identifier
Exp-00000:export terminated unsuccessfully
> Situation 3:
The client for Windows x86 11.1.0.6 exports the Oracle Database for Windows x86 10.2.0.3.
Can be exported, but the export has a lot of ORA-00904 error.
EXP-00008: Encountering ORACLE error 1003
ORA-01003: Statement not parsed
. . Exporting Table Sm_t_sys_param
EXP-00008: Encountering ORACLE error 904
ORA-00904: "MAXSIZE": Invalid identifier
. . Exporting Table Sm_t_sys_workflow
EXP-00008: Encountering ORACLE error 1003
ORA-01003: Statement not parsed
. . Exporting Table Sm_t_user
EXP-00008: Encountering ORACLE error 904
ORA-00904: "MAXSIZE": Invalid identifier
. . Exporting Table sm_t_user_org
EXP-00008: Encountering ORACLE error 1003
ORA-01003: Statement not parsed
> Situation 4:
The client for Windows x86 10.2.0.1 exports the Oracle Database for Windows x86 10.2.0.3.
Export is normal.
As can be summed up, x86_64bit Oracle Export x86bit Oracle will report this error, 11GR1,11GR2 export 10g Oracle will also report this error, only meet 10g x86bit client exports 10g X86bit of Oracle Database to export normally.
[Go] Resolve Oracel database "Exp export always appears ORA-00904"