在本地执行下面语句是报回滚小了
insert into test
SELECT trunc(sysdate - 1),TA.com_code,tb.name,ta.mc,
TB.PP,TB.dzxl,ta.gz,TA.gys,TA.jyfs,        
 TA.zhhsjj,TA.zhbhsjj,round(TA.kl,4),  
TB.lsj,TA.kcsl1,TA.kcbhsje1,TA.kchsje1,
   ta.kcsl1*tb.lsj  
FROM  test@db_db TA,test1@dba_db TB    
WHERE  TA.splb<>'8' AND TA.com_code=TB.code and ta.kcsl1<>0 ;
commit;