Name

REPL_PUBLISH — create publication on publisher

Synopsis

REPL_PUBLISH ( in publication varchar ,
  in log_path varchar ,
  in is_updateable integer ,
  in sync_user varchar );
 

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.

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).

Example

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