Oracle创建dblink

1：赋权限

 GRANT CREATE DATABASE LINK TO USERNAME;

GRANT CREATE PUBLIC DATABASE LINK TO USERNAME;

2:创建dblink

CREATE PUBLIC DATABASE LINK LINKNAME

CONNECT TO USERNAME IDENTIFIDE BY PASSWORD

USING 'IP:PORT/实例名'

3：使用

SELECT * FROM TABLE_NAME@LINKNAME