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
Example 24.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);