語法
1.Create DB Link:
CREATE [PUBLIC] DATABASE LINK
CONNECT TO
IDENTIFIED BY
USING '';

2.Drop DB Link:
DROP [PUBLIC] DATABASE LINK ;

3.Query DB Link:
SELECT db_link, owner, host, username
FROM dba_db_links
ORDER BY db_link;

4.Use DB Link for SELECT:
SELECT * FROM .@;

範例
create public database link oblink4
connect to kory identified by kory
using 'oracle3';

select * from kory.tablea@oblink4


arrow
arrow
    全站熱搜
    創作者介紹
    創作者 korychen 的頭像
    korychen

    korychen

    korychen 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄