oracle创建dblink

创建dblink

create database link dblinkname

connect to user  identified by  password

using 'xyxnb';   --服务名

创建具体如下

create database link LC_ORCL
  connect to jjpj2  identified  by  "jjpj2"
  using '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.178)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )';