REPL_UPDATE_SNAPSHOT
Updates a bi-directional snapshot publication
None REPL_UPDATE_SNAPSHOT
(in item varchar,
in type integer);
Description
This procedure should be used to update a bi-directional snapshot
publication. This procedure pulls all the updates from subscribers
(with conflict resolution) and then pushes all the updates from
publisher to all the subscribers.
Note:
This function should be run on the publisher.
Parameters
item –
Item is a DAV collection or table name.
type –
Type is used to denote the type of Item: 1 if item is a DAV collection, or 2 if item is a table name.
Examples
Updating bi-directional snapshot
The following statement updates bi-directional snapshot publication
of table 'Demo.demo.Shippers'.
SQL> REPL_UPDATE_SNAPSHOT ('Demo.demo.Shippers', 2);