Name
REPL_SUBSCRIBE — add a subscription
Synopsis
REPL_SUBSCRIBE
(
|
in server_name varchar , |
| in publication varchar , | |
| in dav_user varchar , | |
| in dav_group varchar , | |
| in replication_user varchar , | |
| in replication_password varchar , | |
in
sync_user
varchar
); |
Description
This function is used to subscribe to an existing publication,
and to specify the local WebDAV owner for replicated WebDAV content.
Before making a subscription the repl_server()
function
must be called in order to define the publishing server. After making a
subscription it becomes off-line awaiting synchronization from a scheduled
task or call to the repl_sync()
function.
Also the initial data of the subscription will be not loaded until
repl_init_copy()
is called or the initial image
has been loaded.
Parameters
server_name
target publisher server name.
publication
publication account name.
dav_user
A valid local WebDAV user account name that will own local copy. If this is null 'REPLICATION' user account will be created that will be disabled by default.
dav_group
A valid local WebDAV group name to own the local copy.
replication_user
Is used for authentication on the publisher. This should be a valid DB account on publisher.
replication_password
Is used for authentication on the publisher. This should be valid password
for
replication_user
on publisher.
sync_user
A local DB account used to replay replication feeds.
Example
Example 24.333. Subscribing to a publication
This example shows making a subscription to the 'table_publication' published on a 'demo-srv' server. The WebDAV items will belong to the WebDAV administrator.
SQL> DB.DBA.REPL_SUBSCRIBE ('demo-srv','demo-publication', 'dav', 'dav', 'demo', 'demo');