Name
repl_sync — starts the syncing process against an existing subscription
Synopsis
repl_sync
(
|
in publisher varchar , |
| in publication varchar , | |
| in uid varchar , | |
in
password
varchar
); |
Description
This starts the syncing process against an existing subscription. The function returns as soon as the request has been successfully sent. The synchronization will take place in the background. If the syncing process is already underway or if the subscriber is already in sync and connected to the publisher this function has no effect. If there is no connection to the publisher at the time of calling this function and the connection fails and an error is immediately signalled. To initiate a synchronization a valid SQL account must be specified. Also the account must have rights to the publication unless publisher DBA's account is used to connect.
Parameters
publisher
The server name of the publisher.
publication
The name assigned to the publication.
uid
SQL account with rights to the publication, or publishers DBA account credentials will be required.
password
SQL account password.
Example
Example 24.334. Synchronizing a subscription
The following shows requesting a sync from publisher for an existing subscription. The account for authentication is a 'repl_user' SQL account.
SQL> repl_sync ('demo-srv', 'demo-publication', 'repl_user', 'repl_passwd');