oracle dblink 创建查看删除
--创建dblink host:主机名 port 端口 service_name 数据库实例名 (SSID)
CREATE DATABASE LINK link_orcl_test --dblink 连接名称
CONNECT TO orcl_test IDENTIFIED BY orcl_test -- 数据库登录名和密码
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';
--查看dblink
select a.*from dba_db_links a WHERE a.DB_LINK = 'LINK_ORCL_TEST';
--删除dblink
DROP DATABASE LINK LINK_ORCL_TEST;