Exp Export appears: ORA-00904: "Poltyp": Invalid identifier

Related articles:
Exp Export appears: ORA-00904:: Invalid identifier ": http://blog.itpub.net/23135684/viewspace-1336722/

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:

>Scenario 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.

--end--

Export Article Two description:

Transfer from http://www.cublog.cn/u/30637/showart_481055.html
Oracle's IMP/EXP component is our common tool, and one of its operating principles is backwards compatibility . Here are a few of the usage rules and related tests that are summarized accordingly: Rule 1: A low version of Exp/imp can connect to a higher version (or the same version) of the database server, but a higher version of Exp/imp cannot connect to the lower version of the database server 1.1 using the 9i client to connect to the 10g database via IMP

C:\Documents and Settings\yuechaotian>exp Userid=hdtest/[email protected] tables= (AB01) rows=n file=d:\x.dmp Export:release 9.2.0.1.0-production on Wednesday February 20 10:09:55 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production With the partitioning, OLAP and Data Mining options Exported ZHS16GBK character set and Al16utf16 NCHAR character set Note: Table data (rows) will not be exported The specified table is about to be exported through the regular path ... . . Exporting Table AB01 The export was successfully terminated without warning.

1.2 Using a 10g client to connect to a 9i database via IMP: Connection failed (not export failed)

C:\Documents and Settings\yuechaotian>exp userid=hbjb_kf_hd/[email protected] owner=hdtest file=d:\x.dmp Export:release 10.2.0.1.0-production on Wednesday February 20 09:57:22 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. EXP-00056: Encountering ORACLE error 6550 ORA-06550: Line 1th, column 41st: PLS-00302: The ' set_no_outlines ' component must be stated ORA-06550: Line 1th, column 15th: Pl/sql:statement ignored EXP-00000: Export termination failed

Rule 2: High version exp out DMP file, low version cannot imp (DMP file not recognized)2.1 Using 10g client exp out 10g of data

c:\documents and Settings\yuechaotian>exp userid=test/ [email protected] owner=test file=d:\10g.dmp   export:release  10.2.0.1.0-production on  Wednesday  2  month  20 11:16:39   copyright (c) 1982, 2005, oracle.  All rights reserved.   connected to  : Oracle Database 10g Enterprise Edition release 10.2.0.1.0-production with the Partitioning, OLAP and Data Mining options Exported  ZHS16GBK  character set and  al16utf16 nchar  character set   Server use  AL32UTF8  Character set   (  possible character set conversions  )   export successfully terminated  ,  but a warning appears.   c:\documents and settings\yuechaotian>

2.2 Using 9i Client IMP exported DMP file to 10g: can be connected to 10g, but the file is not recognized

C:\Documents and Settings\yuechaotian>imp userid=test/[email protected] fromuser=test touser=test file=d:\10g.dmp Import:release 9.2.0.1.0-production on Wednesday February 20 11:20:33 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production With the partitioning, OLAP and Data Mining options IMP-00010: Not a valid export file, header validation failed IMP-00000: Failed to terminate import successfully C:\Documents and Settings\yuechaotian>

Rule 3: Low version exp out DMP file, high version can imp (backwards compatible)3.1 Using 9i client exp out of data in 9i

C:\Documents and Settings\yuechaotian>exp userid=test/[email protected] owner=test file=d:\9i.dmp Export:release 9.2.0.1.0-production on Wednesday February 20 11:25:04 2008 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0-production With the partitioning, OLAP and Oracle Data Mining options Jserver Release 9.2.0.1.0-production Exported ZHS16GBK character set and Al16utf16 NCHAR character set The specified user is about to be exported ... ...... The export was successfully terminated without warning. C:\Documents and Settings\yuechaotian>

3.2 Using 10g client IMP to 10g database

C:\Documents and Settings\yuechaotian>imp userid=test/[email protected] fromuser=test touser=test file=d:\9i.dmp Import:release 10.2.0.1.0-production on Wednesday February 20 11:28:46 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production With the partitioning, OLAP and Data Mining options Export files created by export:v09.02.00 through the regular path Import is completed in ZHS16GBK character set and Al16utf16 NCHAR character set Import server uses the Al32utf8 character set (possible character set conversions) . . Importing table "Audit_actions" imports 144 rows ...... The import was terminated successfully, but a warning appears. C:\Documents and Settings\yuechaotian>

   Rule 4: Export data from Oracle's lower version can be import to Oracle high, but is limited to adjacent versions of Oracle, such as from Oracle 7 to Oracle 8. For conversions between two nonadjacent versions, such as from Oracle 6 to Oracle 8, you should first enter the data into the intermediate version-oracle 7, and then move from the intermediate database to a later version. I use the IMP feature of 10g to import the DMP file exported by 817 directly into 10g, which is different from the introduction of this rule. (This rule is derived from Gaodaojiang'sOracle Import and Export tool for database porting")

C:\Documents and Settings\yuechaotian>imp userid=test/test Fromuser=scott touser=test file=d:\tyc.dmp Import:release 10.2.0.1.0-production on Wednesday February 20 14:03:33 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connect to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production With the partitioning, OLAP and Data Mining options Export files created by export:v08.01.07 through the regular path Warning: These objects are exported by SCOTT, not the current user Import is completed in ZHS16GBK character set and Al16utf16 NCHAR character set Import server uses the Al32utf8 character set (possible character set conversions) The export server uses the ZHS16GBK NCHAR character set (possible ncharset conversions) . Importing SCOTT's objects to TEST . . Importing table "account" imported 5 rows . . Importing table "BONUS" Imports 0 rows . . Importing table "DEPT" Imports 4 rows . . Importing table "EMP" Imports 14 rows . . Importing table "RECEIPT" Imports 1 rows . . Importing table "Salgrade" Imports 5 rows About to enable constraints ... The import was terminated successfully and no warning occurred. C:\Documents and Settings\yuechaotian>

 The above operation is also applicable for the 10g version of Oraclexe: 

C:\Documents and Settings\yuechaotian>imp userid=test/test Fromuser=scott touser=test file=d:\tyc.dmp Import:release 10.2.0.1.0-production on Wednesday February 20 14:15:51 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connect to: Oracle Database 10g Express Edition Release 10.2.0.1.0-production Export files created by export:v08.01.07 through the regular path Warning: These objects are exported by SCOTT, not the current user Import is completed in ZHS16GBK character set and Al16utf16 NCHAR character set The export server uses the ZHS16GBK NCHAR character set (possible ncharset conversions) . Importing SCOTT's objects to TEST . . Importing table "account" imported 5 rows . . Importing table "BONUS" Imports 0 rows . . Importing table "DEPT" Imports 4 rows . . Importing table "EMP" Imports 14 rows . . Importing table "RECEIPT" Imports 1 rows . . Importing table "Salgrade" Imports 5 rows About to enable constraints ... The import was terminated successfully and no warning occurred. C:\Documents and Settings\yuechaotian>

Exp Export appears: ORA-00904: "Poltyp": Invalid identifier