Mille 发表于 2014-12-5 13:03:34

ORA-03120: two-task conversion routine: integer overflow error

aix6+112.0.3

plsql 上执行

insert into a select * from b@xx;

报错：
ORA-03120: two-task conversion routine: integer overflow error

b表有clob字段

Liu Maclean(刘相兵 发表于 2014-12-7 20:54:24

$ oerr ora 03120
03120, 00000, "two-task conversion routine: integer overflow"
// *Cause:
// *Action:

dblink2端都是11.2.0.3?  如果是 insert into a select * from b@xx where rownum<3;

是否会报错， 如果报错是否产生了trace， 若没有 则做一个 3120 trace name errorstack level 3 后上传

Mille 发表于 2014-12-8 08:50:08

Liu Maclean(刘相兵 发表于 2014-12-7 20:54 static/image/common/back.gif
$ oerr ora 03120
03120, 00000, "two-task conversion routine: integer overflow"
// *Ca ...

insert into a select * from b@xx where rownum<3;
这个不报错

Mille 发表于 2014-12-8 09:17:20

Liu Maclean(刘相兵 发表于 2014-12-7 20:54 static/image/common/back.gif
$ oerr ora 03120
03120, 00000, "two-task conversion routine: integer overflow"
// *Ca ...

dblink 端是9208

Mille 发表于 2014-12-8 10:30:32

Liu Maclean(刘相兵 发表于 2014-12-7 20:54 static/image/common/back.gif
$ oerr ora 03120
03120, 00000, "two-task conversion routine: integer overflow"
// *Ca ...

dblink端是9208

insert into a select * from b@xx where rownum<200; 在sqlplus 、plsql不报错

不过 还是能产生trace
页: [1]
查看完整版本: ORA-03120: two-task conversion routine: integer overflow error