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.
- ORA-00904: "POLTYP": invalid identifier
- ORA-00904: "POLTYP": invalid identifier
- ORA-00904: "POLTYP": invalid identifier 错误
- ORA-00904: : invalid identifier
- ORA-00904::invalid identifier
- ORA-00904:invalid identifier
- ORA-00904: “MAXSIZE”: invalid identifier
- ORA-00904: "MAXSIZE": invalid identifier
- ORA-00904: invalid identifier解决方法
- ORA-00904: "POLTYP": 标识符无效
- ORA-00904: "POLTYP": 标识符无效
- ORA-00904:invalid identifier错误的解决办法
- ORA-00904: "DROP_SEGMENTS": invalid identifier 解决方法
- 解决ORA-00904: invalid identifier标识符无效
- ORA-00904: invalid identifier标识符无效
- Oracle ORA-00904:invalid identifier 标识符无效
- ORA-00904: “OLEVEL”: invalid identifier (exp导出数据报错)
- awrrpt.sql报错:ORA-00904: : invalid identifier
- 链表操作 算法面试题
- C++优先级
- 深入理解Session机制 .
- 多线程下关于硬件资源的释放问题
- gcc与g++区别
- ORA-00904: "POLTYP": invalid identifier
- python datetime时间处理
- 各种面试题资料: 博客、网页、网站、论坛、贴吧
- 软件测试类型/缺陷分类的获取
- Android intent url
- IM-A820L限制GSM,WCDMA上网的原理(其他泛泰机型可参考)7.13
- 使用services.xml发布webservice
- FMDB中常用SQL使用
- shell实用脚本:整理目录文件