ORA-00600 错误,求大神指教
insert into pt_jxc
select "businessdptid", "officeid", "wl", "wh",'', "rq","orig_supid","pp","gdsid","orig_jyfs",sum( "sl"),sum( "hsjhje"),''xsje,'RK','',''
from SD_WHIS_H@gfc where "businessdptid"='04'
group by "businessdptid", "officeid", "wl", "wh", "rq","orig_supid","pp","gdsid","orig_jyfs";
通过oracle透明网关访问的sybase,建立的DBLINK :gfc
select "businessdptid", "officeid", "wl", "wh",'', "rq","orig_supid","pp","gdsid","orig_jyfs",sum( "sl"),sum( "hsjhje"),''xsje,'RK','',''
from SD_WHIS_H@gfc where "businessdptid"='04'
group by "businessdptid", "officeid", "wl", "wh", "rq","orig_supid","pp","gdsid","orig_jyfs";这句有结果集,但
insert 时报错
ORA-00600: internal error code, arguments: [rworupo.2], [6], [4], [], [], [], [], []:
有大侠见过没?怎么解决?
------解决方案-------------------- 为什么要增加双引号呢?先看看能不能从数据库中查出来,再看看插入
------解决方案-------------------- 信息太少,无法定位准确bug,你可以尝试
alter session set "_newsort_enabled" = false;
然后执行sql 看下
---------------------------------------------------------------
QQ号:107644445
QQ群:180042757(注明来自csdn)
邮箱:dba@xifenfei.com
BLOG:http://www.xifenfei.com
------解决方案-------------------- 引用: Quote: 引用:
为什么要增加双引号呢?先看看能不能从数据库中查出来,再看看插入
调用的sybase的表,所以字段必须加“”。
那你能查询出来吗?
------解决方案-------------------- 引用: Quote: 引用:
Quote: 引用:
Quote: 引用:
为什么要增加双引号呢?先看看能不能从数据库中查出来,再看看插入
调用的sybase的表,所以字段必须加“”。
那你能查询出来吗?
必须可以。
那就抱歉了,恕我才疏学浅