Oracle创建DBLink

1、创建DBLink

DBLink名称：NC65DBLINK

连接到数据库：10.19.65.59

端口：1521

实例：ncdbdev

CREATE DATABASE LINK NC65DBLINK CONNECT TO NC651115 IDENTIFIED BY NC651115 USING'(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.19.65.59)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ncdbdev) ) )';

2、删除DBLink

drop public database link NC65DBLINK;

3、访问链接的数据库

select * from sm_userr@NC65DBLINK;