.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], [], [], [], [], []：
为什么要增加双引号呢？先看看能不能从数据库中查出来，再看看插入 alter session set "_newsort_enabled" = false;
然后执行sql 看下
db_link太多，造成不能同时生效使用。修改db_link数量。PL/SQL 用sys用户 sysdba模式登陆
命令窗口
SQL> show parameter open_links;
查看现在的数量
SQL> alter system set open_links=10 scope=spfile;
System altered
SQL> alter system set open_links_per_instance=10 scope=spfile;
System altered