论坛 › Oracle › 创建dblink

hhuxyb 发表于 2011-12-23 02:21

创建dblink

<div id="codeText" class="codeText"><ol style="margin:0 1px 0 0;padding:5px 0;" start="1" class="dp-css"><li><span style="color:#000000;"><span style="color:#0000FF;">create</span> <span style="color:#0000FF;">database</span> link pwd<br></span></li><li>
&nbsp;&nbsp;<span style="color:#0000FF;">connect</span> <span style="color:#0000FF;">to</span>scott<br></li><li>
&nbsp;&nbsp;&nbsp;<span style="color:#0000FF;">using</span> <span style="color:#FF00FF;">'(DESCRIPTION= (ADDRESS=(PROTOCOL=TCP) (HOST=10.192.21.2) (PORT=1521))</span></li><li><span style="color:#FF00FF;">&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (CONNECT_DATA= (SERVICE_NAME=orcl) ) )'</span><span style="color:#0000CC;">;</span></li></ol></div>

查看完整版本: 创建dblink