copy from fail with ORA-03106
同样的方式，在相同的两个库中copy 27张表，仅有2个表报这个错误，不能成功more cf_13859.sql20140126_14_07_38_912.sql
set arraysize 1000
set copycommit 5000
copy from local/12@dbtest to custom/87@mydw APPEND local_area_tm1 using select * from custom.local_area_tm where latn_id=879;
quit
exit
p5501:/home/oracle/copydata/java/copyfrom_temp> sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Sun Jan 26 14:52:47 2014
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> @cf_13859.sql20140126_14_07_38_912.sql
Array fetch/bind size is 1000. (arraysize is 1000)
Will commit after every 5000 array binds. (copycommit is 5000)
Maximum long size is 80. (long is 80)
SQLRCN in cpytbl failed: -2120
SQLRCN in cpyyerr failed: -2120
ERROR:
ORA-03106: fatal two-task communication protocol error
请大家给指点下方向，谢谢！ 不推荐用 copy功能， 特别是在9i上 Liu Maclean(刘相兵 发表于 2014-1-26 21:30 static/image/common/back.gif
不推荐用 copy功能， 特别是在9i上
谢谢，ml，不过后来问题已解决，问题是是客户端和server端 nls_lang不一样，同步后问题就解决了
页:
[1]