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
Example 24.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');