Name
REPL_DROP_SNAPSHOT_PUB — Drop bi-directional snapshot publication
Synopsis
None REPL_DROP_SNAPSHOT_PUB ( |
in item varchar , |
in type integer ) ; |
Description
This procedure drops a snapshot publication.
Parameters
item
Item is a DAV collection or table name.
type
Type is used to denote the type of Item: 1 if item is a DAV collection, or 2 if item is a table name.
Return Types
None.
Examples
Example24.344.Dropping bi-directional snapshot publication
The following statement drops bi-directional snapshot publication of table 'Demo.demo.Shippers':
SQL> DB.DBA.REPL_DROP_SNAPSHOT_PUB ('Demo.demo.Shippers', 2);