oracle exp 无效dblink,【案例】Oracle dblink 数据库连接dblink insert插入数据时异常分析...

天萃荷净

开发DBA反映在测试数据表插入数据，Oracle dblink两库连接插入同步数据时数据量异常

一、诡异Oracle dblink起源

今天开发拿过来一条sql，说有诡异现象，sql如下

INSERT INTO TAB_CS_CALLLOG

select c.user_logon,/*工号*/c.user_name,/*姓名*/a.call_id,/*通话id*/

a.caller_nbr,/*主叫号码*/a.called_nbr,/*被叫号码*/d.start_time,/*呼入时间*/

b.call_time,/*接听时间*/b.end_time,/*结束时间*/b.call_dura,/*时长*/

to_number(b.call_time-d.start_time)*24*3600,/*等待时长*/

decode(c.user_logon,null,0,1),/*类型*/

case

when substr (a.CALLED_NBR,7, 2) = '00'

then '广东移动'

when substr (a.CALLED_NBR,7, 2) = '01'

then '浙江移动'

when substr (a.CALLED_NBR,7, 2) = '02'

then '福建'

when substr (a.CALLED_NBR,7, 2) = '03'

then '四川'

when substr (a.CALLED_NBR,7, 2) = '04'

then '河南'