[Go] Resolve Oracel database "Exp export always appears ORA-00904"

Source: Internet
Author: User
Tags windows x86

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"

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.