Name
REPL_PUB_ADD — add item to a publication
Synopsis
REPL_PUB_ADD
(
|
in publication varchar , |
| in item varchar , | |
| in type integer , | |
| in mode integer , | |
in
procedure_replication_options
integer
); |
Description
This function is used to add items to a pre-existing publication and to set replication options for the published items. Operations concerning the added item will henceforth be logged into the publication's log. Performing this operation will copy the item and optionally its definition to existing subscribers.
Parameters
publication
publication account name.
item
dependent on type should be:
| Valid WebDAV collection full path in local repository. |
| Fully qualified table name. |
| Fully qualified Virtuoso/PL procedure name. |
type
type of item, can accept following types:
| 1 - item is a WebDAV collection. |
| 2 - item is a database table. |
| 3 - item is a Virtuoso/PL procedure. |
mode
mode of remote copy:
| 0 - if publication is removed leave remote copy (on subscribers). |
| 1 - if publication is removed drop remote copy (on subscribers). |
procedure_replication_options
valid only in case of Virtuoso/PL procedure:
| 1 - published procedure calls. |
| 2 - published procedure definition. |
| 3 - published both calls and definition. |
Example
Example 24.324. Adding a table to the publication
This is to add a table Demo.demo.Orders (available in the demo DataBase) to the an existing publication named table_publication. The default flag for removal when publication is dropped is set to off. The parameter mode is NULL as it has effect only for procedures.
SQL> DB.DBA.REPL_PUB_ADD ('table_publication', 'Demo.demo.Orders', 2, 0, NULL);