创建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)
)
)';