REPL_SNP_SERVER
Define bi-directional snapshot replication server name
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
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');