oracle导数据问题，寻求高手支持，感谢ing~~~

yanxhyyy

从oracle for linux  9204导用户数据导oracle for hpunix 9208，目前使用客户端9201导出数据，和导入数据，结果报错，各位好心人，可否指点一下（或者有其他的办法？）～～

. . 正在导入表         "XSRV_SMSPACKAGE_ORDER"          0行被导入
IMP-00041: 警告: 创建的对象带有编译警告
"CREATE FORCE VIEW "YXH"."VIEW_APPLICATION_CHARGE"                      "
"   ("APPLICATION_ID","SCHEME_ID") AS "
"SELECT APPLICATION_ID,SCHEME_ID FROM yxh.XJF_APPLICATION_CHARGE_BUF"
"UNION"
"SELECT APPLICATION_ID,SCHEME_ID FROM yxh.XJF_APPLICATION_CHARGE"
IMP-00003: 遇到 ORACLE 错误 3120
ORA-03120: 双工转换例行程序: 整数溢出
IMP-00003: 遇到 ORACLE 错误 3120
ORA-03120: 双工转换例行程序: 整数溢出
IMP-00000: 未成功终止导入

doni

ORA-03120 two-task conversion routine: integer overflow

Cause: An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous connection. This can happen when an invalid buffer length or too great a row count is specified. It usually indicates a bug in the user application.

Action: Check parameters to Oracle calls. If the problem recurs, reduce all integer parameters, column values not included, to less than 32767.

yanxhyyy

还是不行啊，检查了客户端和服务端的字符集也是一致的，然后减小buffer=32767，重新导入，仍旧报错上面的，还有什么办法啊？

dhhb

客户端先用9204导出,然后再用9208导入,应该就没有问题了.