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;