Oracle数据库创建及使用dblink
1.创建dblink
CREATE PUBLIC DATABASE LINK 数据库链名称 CONNECT TO 登录用户名 IDENTIFIED BY 密码 USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 对方Oracle服务器的IP地址)(PORT = 端口号)) ) (CONNECT_DATA = (SERVICE_NAME = 对方Oracle服务器服务名) ) )'
2.查询dblink
select * from dba_db_links;
3.使用dblink