Name
REPL_PUB_REMOVE — remove item from publication.
Synopsis
REPL_PUB_REMOVE
(
|
in publication varchar , |
| in item varchar , | |
| in type integer , | |
in
flag
integer
); |
Description
This function is used to remove an item from existing publication. It's action is performed on publisher side and depending of flag it can send replication message to subscribers to remove this from subscription.
Parameters
publication
publication account name.
item
dependent on type should be:
| Valid WebDAV collection full path in local repository. |
| Fully qualified table name. |
| Fully qualified Virtuoso/PL procedure name. |
type
type of item, can accept following types:
| 1 - item is a WebDAV collection. |
| 2 - item is a database table. |
| 3 - item is a Virtuoso/PL procedure. |
flag
Behavior on the subscriber side
| NULL - do not send a replication message to the subscribers. |
| 1 - send a message to the subscribers to remove entry from local description. |
Example
Example 24.326. Removal of an item from publication
This will remove the table Demo.demo.Products from publication. Furthermore issuing of the replication messages for this item will be stopped and subscriber will remove this entry from local description.
SQL> DB.DBA.REPL_PUB_REMOVE ('demo-publication', 'Demo.demo.Products', 2, 1);