????dblink?????????

???????????籾?????????????????????????е??????????????????б????????????????dblink?????dblink??????????????????????????????????????????е?????????潲??????????????????д???dblink.

????????dblink??????????????????????dblink??????????д???dblink????????????й?dblink????????sys?????????????????

????select * from user_sys_privs t

????where t.privilege like upper('%link%');

????1 SYS CREATE DATABASE LINK NO

????2 SYS DROP PUBLIC DATABASE LINK NO

????3 SYS CREATE PUBLIC DATABASE LINK NO

????????????????????dblink?????????CREATE DATABASE LINK??????????dblink????????????????????????ò??????CREATE PUBLIC DATABASE LINK??public???????????dblink???????????????????DROP PUBLIC DATABASE LINK??

??????sys????￡???CREATE PUBLIC DATABASE LINK??DROP PUBLIC DATABASE LINK??????????????

????grant CREATE PUBLIC DATABASE LINK??DROP PUBLIC DATABASE LINK to scott;

?????????scott???????????????

????1.????dblink??????????????????????tnsnames.ora????????????????????????

????create public database link

????to_bylw connect to scott identified by tiger using 'bylw';

????????to_bylw????????dblink?????bylw??????????????????scott/tiger??????????????????/??????????????????????dblink????????????'bylw'??scott.tb_test???sql??????????

????select * from scott.tb_test@to_bylw;

????2.????dblink??????????????????????tnsnames.ora??????????????????????????

create database link to_test
connect to scott identified by tiger
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bylw)
)
)';

??????????????????????tnsnames.ora????е???????????????dblink?????檔????????tnsnames.ora???????????￡?

bylw =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bylw)
)
)