bz_int_pr_crdblink.sql

来自「oracle9i+j2ee开发aq oracle9i+j2ee开发aq or」· SQL 代码 · 共 22 行

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

define bz = &1

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

drop database link loopback;

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

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