dblink创建

dblink: 注用户名和密码有特殊字符时,必须用双引号.
create database link LK_saleb246
　　 connect to saleb identified by ***
　　 using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = db10g)
      (SERVER = DEDICATED)
    )
  )';
 
create database link LK_oradhyx
　　 connect to myd_fx identified by "***"
    using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oradhyx)
      (SERVER = DEDICATED)
    )
  )';