高手啊,,求求你帮帮忙,,万分感谢!!!
问题描述:
两个DB,一个在成都,一个在深圳,在成都建了DBLINK,测试OK,
向成都DB写入数据时代码如下:
DECLARE
c_date constant DATE:=SYSDATE; --记录当前时间,好插入到表中,
BEGIN
INSERT INTO mix.a@cd
select b.refno10 as shipno,a.lotname as sn,b.trackno as cartonid,''as applematnr,'CD'as shipfrom,c_date as lasttime
from tablea a,tableb b where a.carrirename = b.trackno and carrirename in (select trackno from table c where c.flge ='M')
END;
运行时没有问题,,很快就将数据写好。
问题一:但是我将c_date 之直接用sysdate来代替,捞取速度没有问题,不到1s,但是完整运行就会卡死,,为什么?
问题二:在用同样的方法想深圳那边表中写,就算是用哪个c_date也会卡死,用sysdata替代一样会卡死,但是捞取一点问题都没有,我将c_date as lasttime那个栏位去掉后,单独使用update进行更新,向cd和sz写数据都没得问题。cd和sz两张表完全一样。
向深圳DB写数据代码如下:
DECLARE
c_date constant DATE:=SYSDATE; --记录当前时间,好插入到表中,
BEGIN
INSERT INTO mix.a@sz
select b.refno10 as shipno,a.lotname as sn,b.trackno as cartonid,''as applematnr,'CD'as shipfrom,c_date as lasttime
from tablea a,tableb b where a.carrirename = b.trackno and carrirename in (select trackno from table c where c.flge ='M')
END;