Previous |
Next |
Before dropping an object from a master group, make sure no materialized views depend on the object. After suspending the replication activity of a master group, complete the following steps to remove objects from a master group:
In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.
Click Data Movement.
Under the Advanced Replication section, click Manage.
The Administration Overview page appears.
Under the Multimaster Replication section, click the number link next to Master Groups to open the Master Groups page.
Select the target master group that contains the object that you want to remove and click Edit.
The General subpage of the Edit Master Group page appears.
Click Objects.
The Objects subpage of the Edit Master Group page appears.
Select the objects that you want to remove and click Remove.
After you have removed objects from the master group, optionally apply the administrative requests (Applying Administrative Requests) that result from your changes at all master sites, and then resume replication activity for the master group (Resuming Replication Activity for a Master Group).
Note: When you drop a replicated object from a master group, Oracle Enterprise Manager automatically removes all corresponding system-generated objects that were necessary to support the replicated object.
API Equivalent: DBMS_REPCAT.DROP_MASTER_REPOBJECT