oracle数据链

 创建用户可以先用已有的用户来创建用户
--------创建连接链
create database link con_Link
　　 connect to connzbdc identified by zbdc
　　 using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.50.12)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mptmsm)
    )
  )';
/************************************/
对方数据库用户名：connzbdc 密码：zbdc
ip：172.18.50.12  端口：1521
mptmsm为数据库的sid
查看数据库对应的sid:select instance_name from v$instance;
/************************************/
查看是否连接上
SELECT * FROM ELECTRICITY_INFO@con_Link;