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


请大家给指点下方向，谢谢！

Liu Maclean(刘相兵

不推荐用 copy功能， 特别是在9i上

北柏

Liu Maclean(刘相兵 发表于 2014-1-26 21:30
不推荐用 copy功能， 特别是在9i上

谢谢，ml，不过后来问题已解决，问题是是客户端和server端 nls_lang不一样，同步后问题就解决了