bz_int_pr_crdblink.sql

oracle9i+j2ee开发aq oracle9i+j2ee开发aq oracle9i+j2ee开发aq

REM script name: bz_cr_dblink.sql
REM Creates a dblink "loopback" to demostrate propagation 
REM 
REM
REM version: 9i
REM

REM =======================================================
REM cleanup section
REM =======================================================

drop public database link loopback;

REM =======================================================
REM Create a loopback to the current database
REM Replace bgoyaldb by the service name of your database
REM =======================================================

CREATE public DATABASE LINK loopback CONNECT TO "bob" IDENTIFIED BY "welcome" USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=http)(HOST=bgoyal-sun.us.oracle.com)(PORT=7777)))';