Co2y's Blog

oracle建立databaselink

发表于 | 分类于 | 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
SQL>CREATE PUBLIC DATABASE LINK xxx
CONNECT TO user identified by passwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(PORT = 1521))
)
(CONNECT_DATA =
(service_name=xe
)
)';
CREATE PUBLIC DATABASE LINK "XXXX"
   CONNECT TO "USER" IDENTIFIED BY VALUES '05A36CC2DA77E7B3B758F0A763041F08EF35CE8688B5E673AA'
   USING '172.17.0.2';