Name

repl_disconnect — terminates communication with a replication publisher

Synopsis

repl_disconnect ( in publisher varchar );
 

Description

This terminates any communication with the publisher. Any pending synchronization communication is disconnected and all subscribed publications are marked as 'OFF'. The effect is reversed on a subscription by subscription basis by calling repl_sync for each.

Parameters

publisher

Publisher's name.

Example

Example 24.319. Disconnecting from publisher server 'demo-srv'.

This is to disconnect from the publisher server 'demo-srv', the all subscriptions to this server will be disconnected.

SQL> repl_disconnect ('demo-srv');