Oracle9i连接Sybase的透明网关配置(2)

connect_descriptor=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST= host_name)

(PORT= port_number)

)

(CONNECT_DATA=

(SID= gateway_sid))

(HS=OK))

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

sybs=

(DESCRIPTION=

(ADDRESS_LIST =

(ADDRESS=(PROTOCOL=TCP)(HOST= dw-server1)(PORT= 1521))

)

(CONNECT_DATA=

(SID= tg4sybs)

)

(HS=OK)

)
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

CREATE  DATABASE LINK sybs  CONNECT TO sa 

IDENTIFIED BY prient  

USING 'SBYS' ；

SQL〉select "a" from "b"@sybs;