创建DBLINK

创建PUBLIC databaselink需要sys权限
创建用户 databaselink需要用户权限

CREATE DATABSE LINK LINK_NAME CONNECT TO USERNAME IDENTIFIED BY PASS USEING '本地NET命名或者连接字符串'

(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 7.0.2.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = UPRR)
    )
  )