Oracle Create DBLink

DROP PUBLIC DATABASE LINK ORA11G_DBLINK;


CREATE   PUBLIC   DATABASE LINK ORA11G_DBLINK
CONNECT TO SYSTEM IDENTIFIED BY ORACLE
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.10.201)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = ora11g)))';

posted @ 2015-11-04 22:51  全威儒  阅读(319)  评论(0)    收藏  举报