1.查询已有dblink:
select * from dba_db_links
2.创建dblink:
create database link dblinkName --连接名
connect to username identified by password -- 用户名,密码
using 'ip:port/databaseName' -- ip:端口/数据库名
3.查询示例
select * from uf_mytable@dblinkName