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  全威儒  阅读(309)  评论(0编辑  收藏  举报