Name
REPL_INIT_SNAPSHOT — Initializes a bi-directional snapshot publication
Synopsis
None
REPL_INIT_SNAPSHOT
(
|
in server varchar , |
| in item varchar , | |
| in type integer , | |
in
how_many
integer
); |
Description
This procedure should be used to initialize a bi-directional snapshot publication.
![[Note]](images/note.png)
|
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.
how_many
This parameter specifies the number of copied rows per transaction during doing initial copy in table case (when type is 2).
Return Types
None.
Examples
Example 24.345. Initializing bi-directional snapshot subscription
The following statement does initial copy of data for bi-directional snapshot subscription of server with DSN 'localhost:1121' for table 'Demo.demo.Shippers':
SQL> DB.DBA.REPL_INIT_SNAPSHOT (REPL_SERVER_NAME ('localhost:1121'), 'Demo.demo.Shippers', 2);