1、通过脚本命令创建db_link:
CREATE DATABASE LINK LINK_NAME
CONNECT TO USERNAME IDENTIFIED BY PASSWORD
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)';
注意红色部分;