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