REPL_PUB_REMOVE
remove item from publication.
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
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);