Oracle建立Database Link

 1 create database link dblink_TEST
2 connect to wings identified by wings
3 using '(DESCRIPTION =
4 (ADDRESS_LIST =
5 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
6 )
7 (CONNECT_DATA =
8 (SERVICE_NAME = TESTDB)
9 )
10 )';
posted @ 2011-12-18 12:57  wingsless  阅读(282)  评论(0编辑  收藏  举报