create database link dw_xnh_LINK
connect to dw_xnh identified by dw_xnh
using ‘(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.181)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)‘
原文：http://www.cnblogs.com/liujie-e2/p/7389597.html