高版本客户端exp导出Oracle数据报错ORA-00904及EXP-00008
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.
我译成中文了。想看中文点进去。
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.
我译成中文了。想看中文点进去。
这是意料之中的事情。
exp工具的版本必须等于导入/导出两边数据库中的最早版本。在这个问题中，源数据库的版本是10.2.0.3.0而目标数据库是10.2.0.4.0，所以应该使用版本为10.2.0.3.0的exp工具。
之所以新版的工具不能用在老版上面，是因为：
导出工具需要持续访问词典对象，如SYS.EXU9LOB。
从102.0.4.0开始，oracle公司引入了一个新的字段，如“IFREEPOOL".这些字段在10.2.0.3.0中是没有的，所有客户端无法正确处理，从而报ORA-00904/EXP-000008的错误。
总之，10.2.0.4.0版的客户端无法导出10.2.0.3.0的数据库。
解决方法：使用导入/导出两边的两个数据库中较早版本的那个客户端来导出。
Trackbacks
Trackback specific URI for this entry
No Trackbacks
