# 22. Virtuoso Functions Guide - REPL_PUBLISH

Chapter Contents | Prev | Next
Keyword Search:
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
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_PUBLISH

create publication on publisher
REPL_PUBLISH (in publication varchar, in log_path varchar, [in is_updateable integer], [in sync_user varchar]);
Parameters
publication – Publication name. It must not contain spaces or special symbols.
log_path – Full path and filename to the file where transactions to this account will be stored.
is_updateable – If this parameter is specified and it is non-zero an updateable publication is created.
sync_user – Local DB account used to replay replication feeds from subscribers (when publication is updateable).
Description

This function starts a publication and associates a file system file to it. The file will be used to log transaction records associated to the publication. The server will periodically start new files, so that replication log files do not grow indefinitely. New files will go to the same directory as the initial one and will have names suffixed with the date and time of their creation.

Example
Creating an updateable publication

This will create an updateable publication'demo-publication' with log 'demo-publication.log'. Replication feeds from subscribers will be replayed by used 'demo'.

    SQL> DB.DBA.REPL_PUBLISH ('demo-publication', 'demo-publication.log', 1, '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_revoke()

repl_sched_init()

repl_server()

repl_server_rename()

repl_stat()

repl_status()

repl_subscribe()

repl_sync()

repl_sync_all()

repl_text()

repl_this_server()

repl_unpublish()

repl_unsubscribe()