1、已经配置本地服务
以下是引用片段:
create public database
link fwq12 connect to fzept
identified by neu using 'fjept'
CREATE DATABASE LINK数据库链接名CONNECT TO 用户名 IDENTIFIED BY 密码 USING ‘本地配置的数据的实例名’;
2、未配置本地服务
以下是引用片段:
create database link linkfwq
connect to fzept identified by neu
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.142.202.12)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = fjept)
)
)';
CREATE DATABASE LINK "DBCENTER_LINK" CONNECT TO "dbcenterzx" IDENTIFIED BY "dbcenterzx" USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.73)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dataorcl) ) )'
-----------------------------------------------------------------------------------
手机app、网站开发、系统定制 优惠中。。。
详情请登录http://www.junchuangsoft.com/