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');