--DBLink;
--查看DBLink
select * from dba_db_links;
--授權(quán)
grant create public database link;
--或者create database link to myAccount;

--創(chuàng)建(如果在create之后不加public,則創(chuàng)建的dblink就不是公共的,就只有創(chuàng)建者可以使用了.)
create database link TO_anxin connect to anxindev identified by axdev20170308
　　 using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 139.199.7.38)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)';

--查詢
select * from anxindev.fdcom@TO_anxin;

-- 不想讓使用的人知道database link的名字的時(shí)候
-- 建一個(gè)別名(同義詞)包裝一下

創(chuàng)建同義詞權(quán)限：grant create synonym to scott
CREATE SYNONYM FDTest FOR FDTest@TO_anxin;
SELECT * FROM FDTest;
--刪除同義詞： [public]
drop synonym FDTest;
--查看所有同義詞：
select * from dba_synonyms where table_name like '%fdcom';
-- 或者，也可以建立一個(gè)視圖來(lái)封裝
--CREATE VIEW table_name AS SELECT * FROM table_name@database link;

--刪除
drop public database link TO_anxin;
-- 刪除非public類型的database link
-- 注意：只有owner自己能刪除自己的非public類型database link
DROP database link TO_anxin;