Name
REPL_UPDATE_SNAPSHOT — Updates a bi-directional snapshot publication
Synopsis
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]](images/note.png)
|
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.
Return Types
None.
Examples
Example 24.346. 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);