Name

REPL_CREATE_SNAPSHOT_PUB — Create bi-directional snapshot publication

Synopsis

None REPL_CREATE_SNAPSHOT_PUB ( in item varchar ,
in type integer );

Description

This procedure should be used to create a bi-directional snapshot publication. If the item parameter is a table then this procedure creates an updateable snapshot log and generates an updating procedure.

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.341.Creating bi-directional snapshot publication

The following statement creates bi-directional snapshot publication of table 'Demo.demo.Shippers':

SQL> DB.DBA.REPL_CREATE_SNAPSHOT_PUB ('Demo.demo.Shippers', 2);
      

The following statement creates bi-directional snapshot publication of DAV collection '/DAV/doc':

SQL> DB.DBA.REPL_CREATE_SNAPSHOT_PUB ('/DAV/doc', 1);