--创建:
create database link DBLINK_NAME
connect to USER_NAME identified by PWDusing '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SN)
)
)';
--删除
-- Drop existing database link
drop database link DBLINK_NAME;
--查询:
select * from table_name@DBLINK_NAME