Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

Dropping a Snapshot Object Group

To drop a snapshot object group from your replicated environment, call the DROP_SNAPSHOT_REPGROUP procedure in the DBMS_REPCAT package, as shown in the following example:

DBMS_REPCAT.DROP_SNAPSHOT_REPGROUP(
    gname         => 'accts', 
    drop_contents => TRUE);

In this example, the ACCTS replicated object group is dropped from your current snapshot site. All objects generated to support the replicated object group are dropped, and the replicated objects in the object group no longer propagate changes to their former master site.

To drop these objects completely, you must set DROP_CONTENTS to TRUE, as shown in the example. If you set DROP_CONTENTS to FALSE, the trigger generated to support replication of snapshot modifications remains.

Additional Information: The parameters for the DROP_SNAPSHOT_REPGROUP procedure are described in Table 12 - 135, and the exceptions are listed in Table 12 - 136.

Contents Index Home Previous Next