Oracle7 Server Distributed Systems Volume II: Replicated Data

Dropping a Replicated Object

To drop a replicated object from a snapshot site, call the DROP_SNAPSHOT_REPOBJECT procedure in the DBMS_REPCAT package at that snapshot site, as shown in the following example:

DBMS_REPCAT.DROP_SNAPSHOT_REPOBJECT(
    sname        => 'acct_rec', 
    oname        => 'emp', 
    type         => 'snapshot', 
    drop_objects => TRUE);

In this example, the EMP snapshot will no longer be replicated, all supporting objects will be dropped, and the snapshot itself will be dropped. Had DROP_OBJECTS been set to FALSE, the snapshot would no longer be replicated, but the snapshot would remain in the schema until you removed it using the DROP SNAPSHOT command. The trigger and associated package used to add transactions to the deferred transaction queue, as well as any queued transactions, are not dropped until you drop the snapshot itself.

Additional Information: The parameters for the DROP_SNAPSHOT_REPOBJECT procedure are described in Table 12 - 137, and the exceptions are listed in Table 12 - 138.