dblink创建，查询，删除

`dblink创建，查询，删除，
select owner,object_name from dba_objects where object_type='DATABASE LINK';--查询现有的DBLINK
1：创建dblink：

create public database link hr_cf_link
connect to hruser IDENTIFIED BY hruser
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =134.64.105.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ahtest)
)
)';

已知远程表a

2：查询：

select * from a@ link hr_cf_link ;//查询对方表要用表明，加上@，加上diblink链接名：link hr_cf_link
对远程表的查询。

3：创建同义词

CREATE SYNONYM hr_tocfuser FOR a@hr_cf_link;

同义词创建后，我们以进行如下进行数据查询

select * from hr_tocfuser;//来查询远程表

4：删除dblink

drop public database link hr_cf_link ;

5:删除同义词

drop synonym 《同义词名称》
`