語法
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
請先 登入 以發表留言。