创建dblink

create /*public*/ database link ekp_link

 connect to 用户名 identified by 密码

 using '(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.1)(PORT = 1500))

    )

    (CONNECT_DATA =

      (SID = orcl)

    )

  )';


测试连接是否成功  

--select * from ekp_scc_contractchange_detail@ekp_link

删除DbLink

--drop /*public*/ database link ekp_link;

注意事项

ebs复制环境时,注意删除DbLink