创建DBLINK

以下是引用片段：

　　create public database

　　link fwq12 connect to fzept

　　identified by neu using 'fjept'

　　CREATE DATABASE LINK数据库链接名CONNECT TO 用户名 IDENTIFIED BY 密码 USING ‘本地配置的数据的实例名’;

--创建DBLINK

CREATE DATABASE LINK finance_LINK CONNECT TO dep2011 IDENTIFIED BY dep2011 USING '(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.253)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SID = finance)

      (SERVICE_NAME = finance)

    )

  )';