REPL_CREATE_SNAPSHOT_SUB
Create bi-directional snapshot subscription to an existing publication.
None REPL_CREATE_SNAPSHOT_SUB
(in server varchar,
in item varchar,
in type integer);
Description
This procedure should be used to create a bi-directional snapshot subscription.
Note:
This function should be run on publisher.
Parameters
server –
The name of the server defined with REPL_SNP_SERVER().
The name of the server can be obtained using REPL_SERVER_NAME()
function.
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
Creating bi-directional snapshot subscription
The following statement creates bi-directional snapshot subscription
of server with DSN 'localhost:1121' for table 'Demo.demo.Shippers':
SQL> DB.DBA.REPL_CREATE_SNAPSHOT_SUB (REPL_SERVER_NAME ('localhost:1121'), 'Demo.demo.Shippers', 2);
The following statement creates bi-directional snapshot subscription
of server with DSN 'localhost:1121' for DAV collection '/DAV/doc':
SQL> DB.DBA.REPL_CREATE_SNAPSHOT_SUB (REPL_SERVER_NAME ('localhost:1121'), '/DAV/doc', 1);