www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
RDF data
Remote SQL Data Source
Replication
repl_add_cr
repl_add_dav_cr
repl_add_snapshot_cr
repl_create_snapshot...
repl_create_snapshot...
repl_drop_snapshot_p...
repl_drop_snapshot_s...
repl_grant
repl_init_copy
repl_init_snapshot
repl_publish
repl_pub_add
repl_pub_init_image
repl_pub_remove
repl_revoke
repl_sched_init
repl_server
repl_server_name
repl_snp_server
repl_stat
repl_subscribe
repl_unpublish
repl_unsubscribe
repl_update_snapshot
repl_disconnect
repl_new_log
repl_purge
repl_server_rename
repl_status
repl_sync
repl_sync_all
repl_text
repl_this_server
sub_schedule
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY

Functions Index

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 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
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');
      
See Also

sub_schedule()

repl_disconnect()

repl_grant()

repl_init_copy()

repl_new_log()

repl_pub_add()

repl_pub_init_image()

repl_pub_remove()

repl_publish()

repl_revoke()

repl_sched_init()

repl_server()

repl_server_rename()

repl_stat()

repl_status()

repl_sync()

repl_sync_all()

repl_text()

repl_this_server()

repl_unpublish()

repl_unsubscribe()