[size=large][b][color=red]--1. Create database link [/color][/b][/size]
create database link [b][color=red]CIMLINK[/color][/b]
connect to [b][color=red]CCBCIM [/color][/b]identified by [color=red]password[/color]
using '(
DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
([color=red]HOST [/color]= 11.40.33.11)
(PORT = 1550)
)
)
(CONNECT_DATA =(SERVICE_NAME = CDBINST1) )
)';
[color=red][b]解释:[/b][/color]CIMLINK - DBlink的名字
CCBCIM - 要连接的数据库名字
password - 要连接数据库的密码
HOST - 要连接数据库的物理IP
[size=large][b][color=red]--2. Create the synonym [/color][/b][/size]
create or replace synonym [color=red]PPMS_CIM_CLIENT_INFO[/color]
for [color=red]CCBCIM_CLIT_BASIC[/color]@[color=red]CIMLINK[/color];
[color=red][b]解释:[/b][/color]PPMS_CIM_CLIENT_INFO - 同义词的名字,可以当正常表来用
CCBCIM_CLIT_BASIC - DBLink到实际库里的表名
CIMLINK - DBLink的名字
create database link [b][color=red]CIMLINK[/color][/b]
connect to [b][color=red]CCBCIM [/color][/b]identified by [color=red]password[/color]
using '(
DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
([color=red]HOST [/color]= 11.40.33.11)
(PORT = 1550)
)
)
(CONNECT_DATA =(SERVICE_NAME = CDBINST1) )
)';
[color=red][b]解释:[/b][/color]CIMLINK - DBlink的名字
CCBCIM - 要连接的数据库名字
password - 要连接数据库的密码
HOST - 要连接数据库的物理IP
[size=large][b][color=red]--2. Create the synonym [/color][/b][/size]
create or replace synonym [color=red]PPMS_CIM_CLIENT_INFO[/color]
for [color=red]CCBCIM_CLIT_BASIC[/color]@[color=red]CIMLINK[/color];
[color=red][b]解释:[/b][/color]PPMS_CIM_CLIENT_INFO - 同义词的名字,可以当正常表来用
CCBCIM_CLIT_BASIC - DBLink到实际库里的表名
CIMLINK - DBLink的名字