创建db_link
-- Create database link
create public database link dblinkName
connect to 数据库账号 identified by 数据库密码
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 数据库ip)(PORT = 数据库端口)))(CONNECT_DATA =(SERVICE_NAME = 数据库服务名)))';
数据库服务名查询
select name from v$database ;
删除db_link
drop public database link DB_HITMOOC;
使用db_link
select * from tablename@dblinkName --(只有查询)
select t.*, t.rowid from tablename@dblinkName t --(可以修改,立即生效)