ORA-00904: "POLTYP": invalid identifier

来源:互联网 发布:淘宝联盟订单不结算 编辑:程序博客网 时间:2024/05/16 00:54

oracle客户端和服务器端在不同版本下时,导出有时会出现ORA-00904错误,如下:默认环境变量只有11G的路径。

C:\Users\Administrator>exp scott/tiger file=d:\emp.dmp tables=emp

Export: Release 11.2.0.1.0 - Production on Wed Jul 11 17:28:34 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully

--切换路径或者设置环境变量

D:\oracle\product\10.2.0\db_1\BIN>exp scott/tiger file=d:\emp.dmp tables=emp

Export: Release 10.2.0.4.0 - Production on Wed Jul 11 17:30:38 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                            EMP         14 rows exported
Export terminated successfully without warnings.

原创粉丝点击