查询
select * from dba_objects where object_type='DATABASE LINK';
创建
create database link TO_TIKU
connect to tiku identified by pmphtkzving
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.223)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORACLE)
)
)';
查询使用
select * from dual@TO_TIKU;
删除
drop database link TO_TIKU;