bz_prp_cr_dblink.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_adm = &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 bz_adm IDENTIFIED BY &bz_adm USING 'bgoyaldb';