创建DB link以及同义词
<p> create database link Dblink<br/> connect to xxx identified by xxxx<br/> using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = <img src="http://www.czidea.cn/ueditor/themes/default/images/spacer.gif"/>1111111)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';<br/> <br/> <br/>create or replace synonym cccc for xxxxx.tableName@DBLINK;<br/></p><p><br/></p><p>create or replace synonym cccc for xxxxx.tableName</p><p><br/></p>
页:
[1]