REPL_SUBSCRIBE
add a subscription
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 syncronization 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
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');