Prev Up Next
REPL_INIT_SNAPSHOT Home REPL_SNP_SERVER

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] 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

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

Prev Up Next
REPL_INIT_SNAPSHOT Home REPL_SNP_SERVER