查询已经创建的dblink
select owner,object_name from dba_objects where object_type='DATABASE LINK';
select * from dba_db_links;
- oracle数据库直接找对应目录
创建
CREATE DATABASE LINK dblinkname(改)
CONNECT TO dbuser(改) IDENTIFIED BY dbuserpasswd(改)
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.88.5.134(改))(PORT = 1521(改))))(CONNECT_DATA =(SERVICE_NAME = orcl(改))))';
需要注意的是 CREATE DATABASE ,中间可以增加public,表示这个数据库的所有用户都可以使用
删除
drop database link dblinkname;
如果该dblink,是public,需要在drop后面加上public
使用
select * from tablename@dblinkname