Oracle exp 导出数据错误解决方法

最新推荐文章于 2021-04-08 01:01:06 发布

lyc417356935

最新推荐文章于 2021-04-08 01:01:06 发布

阅读量3.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle数据库

本文链接：https://blog.youkuaiyun.com/lyc417356935/article/details/50384645

Oracle数据库专栏收录该内容

7 篇文章

订阅专栏

本文介绍了一个关于使用Oracle exp工具导出数据时遇到的ORA-00904错误，并给出了详细的解决方法。问题根源在于客户端与服务器版本不匹配。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

问题：用exp方式导出数据报错

Export: Release 11.2.0.3.0 - Production on Tue Dec 22 15:47:49 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

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

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user TEST 
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user TEST 
About to export TEST's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export TEST's tables via Conventional Path ...
EXP-00008: ORACLE error 904 encountered
ORA-00904: "POLTYP": invalid identifier
EXP-00000: Export terminated unsuccessfully

解决方法：
报错里面主要是因为Oracle客户端版本和数据库版本不一致导致的，Oracle客户端是11g的但是Oracle服务器是10g，换成10g客户端问题解决。