Oracle DB link

drop database link jc_zd

create database link jc_zd
connect to dzjc identified by "12345678"
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 19.104.24.19)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = jc)))';

 

create database link LINK_SIT_UAT

  connect to omproute IDENTIFIED BY OMPUATDB

  using '(DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.202.34.215)(PORT = 1521))

    (CONNECT_DATA =

      (SERVICE_NAME = ompuat)

    )

  )';

 

建立了连接直接调用

 insert into t_jc_xzxk_shouli
               (ywlsh,sjbbh,spsxbh,spsxzxbh,yxtywlsh,spsxmc,gdblsx,gdblsxdw,gdsf,xmmc,flgdgxd,fsywgxd,
                sqdwhsqrxm,sqdwjbrxm,sqdwlxdh,sqdwjbrsj,sqdwjbryj,sljgzzjgdm,sljgmc,sldwcbrxm,sldwcbrgh,
                sljtdd,slsj,hzbh,slzlqd,slyf,bslyy,tjfs,bz,byzda,byzdb,byzdc,byzdd/*,status,inputmode,net,
                makeperson,maketime,spperson,sptime,spstatus,dealresult,makepername*/
               )
        select t.ywlsh,t.sjbbh,t.spsxbh,t.spsxzxbh,t.yxtywlsh,t.spsxmc,t.gdblsx,t.gdblsxdw,t.gdsf,t_proxmmc,t.flgdgxd,t.fsywgxd,
               t.sqdwhsqrxm,t.sqdwjbrxm,t.sqdwlxdh,t.sqdwjbrsj,t.sqdwjbryj,t.sljgzzjgdm,t.sljgmc,t.sldwcbrxm,t.sldwcbrgh,
               t.sljtdd,t.slsj,t.hzbh,t.slzlqd,t.slyf,t.bslyy,t.tjfs,t.bz,t.byzda,t.byzdb,t.byzdc,t.byzdd/*,t.status,t.inputmode,t.net,
               t.makeperson,t.maketime,t.spperson,t.sptime,t.spstatus,t.dealresult,t.makepername*/
         from t_jc_xzxk_shouli@TEST t where t.ywlsh=trim(t_ywlsh);

上面的蓝色是主要部分。

 

--01创建序列

create sequence SEQ_SENDHDFS_ROUTE

minvalue 1

maxvalue 99999999999999999999

start with 1

increment by 1

cache 200;

 

--02创建job

declare  waybill_basic_job number;  

begin  

dbms_job.submit(waybill_basic_job,'STP_TEMP_WAYBILL;',sysdate,'TRUNC(sysdate+1) +1/24');  

commit;  

end;

 

begin   

dbms_job.remove(900);  

commit;  

end; 

 

--03创建同义词

create synonym TM_CVYGAP_ROUTE for OMPROUTE.TM_CVYGAP_ROUTE;

commit;