Name
REPL_SNP_SERVER — Define bi-directional snapshot replication server name
Synopsis
varchar REPL_SNP_SERVER ( |
in dsn varchar , |
in uid varchar , | |
in pwd varchar ) ; |
Description
This function should be used to define a server for bi-directional snapshot replication.
Parameters
dsn
Dsn is a data source name.
uid
Uid is data source user name.
pwd
Uid is data source password.
Return Types
REPL_SNP_SERVER() returns remote server name which can be used
in calls to REPL_CREATE_SNAPSHOT_SUB()
, REPL_DROP_SNAPSHOT_SUB()
and REPL_INIT_SNAPSHOT_SUB()
functions.
Examples
Example24.347.Defining bi-directional snapshot replication server
The following statement defines bi-directional replication server for server with DSN 'localhost:1121':
SQL> REPL_SNP_SERVER ('localhost:1121', 'dba', 'dba');