Name

REPL_UNPUBLISH — drop publication on publisher

Synopsis

REPL_UNPUBLISH ( in publication varchar );
 

Description

This function is used to remove from current replication set an existing publication. The replication messages for all existing items will be stopped, so the last replication message will instruct the subscribers that this publication is dropped. On subscriber side depending of the copy mode of items they can be removed or not, but the description entry for that publication will be removed explicitly. Any existing grants to the publication being dropped will be revoked.

Parameters

publication

publication account name.

Example

Example 24.338. Dropping a publication

The following statement will remove the publication 'demo-publication' account from current replication set.

SQL> DB.DBA.REPL_UNPUBLISH ('demo-publication');