高版本客户端exp导出Oracle数据报错ORA-00904及EXP-00008
在使用一台安装在Windows Server 2008 x64上的Oracle 10.2.0.4.0导出AIX上的10.2.0.3.0数据时,报以下错误
Export: Release 10.2.0.4.0 - Production on Fri Jun 5 23:55:10 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character setAbout to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user CNDERP
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user CNDERP
About to export CNDERP's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export CNDERP's tables via Conventional Path ...
. . exporting table A001_TEMP 36078 rows exportedEXP-00008: ORACLE error 904 encountered
ORA-00904: "IFREEPOOL": invalid identifier
. . exporting table CARRYMANAGE2 144 rows exported
. . exporting table CARRYNOTIFY
EXP-00008: ORACLE error 1003 encountered
ORA-01003: no statement parsed. . exporting table ZR_99 182 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
EXP-00008: ORACLE error 904 encountered
ORA-00904: "OLEVEL": invalid identifier
EXP-00000: Export terminated unsuccessfully
错误主要出现在存在LOB对象的表,看来不能使用高版本的客户端来EXP数据,而用低版本的客户端EXP数据一般没有问题。
在Metalink上的Note:726182.1中说:
Cause
This is an expected behaviour.The version of the Export utility must be equal to the earliest version of the source or target database. Here, the source database is based on release 10.2.0.3.0 and hence the export client has to be a version 10.2.0.3.0.
An export client of a later release cannot be used for the following reasons:
The export utility is continuously accessing dictionary objects such as SYS.EXU9LOB.
Starting with release 10.2.0.4.0 we introduced additional columns such as 'IFREEPOOL'. This column is not available in 10.2.0.3.0 and hence the client cannot handle this and ORA-00904/EXP-00008 appears.Client 10.2.0.4.0 is not supported to export from 10.2.0.3.0 database.
FIX
The version of the Export utility must be equal to the earliest version of the source or target database.
参考eygle的文章:http://www.eygle.com/archives/2009/06/export_ora_00904_ifreepool.html
技术组织
最近评论
历史归档
广告位






