Adding Objects to a Master Group

You can add new replication objects to the master group, including tables, views, synonyms, indexes, triggers, procedures, functions, and packages. To do this, you must be at the master definition site and must ensure that the status of the master group "quiesced" before proceeding.

To add one or more objects to a master group:

1. In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.

2. Click Data Movement.

3. Under the Advanced Replication section, click Manage.

   The Administration Overview page appears.

4. Under the Multimaster Replication section, click the number link next to Master Groups to open the Master Groups page.

5. Click Edit.

   The General subpage of the Edit Master Group page appears.

6. Click Objects.

   The Objects subpage of the Edit Master Group page appears.

7. Click Add.

   The Add Objects page appears.

8. Specify whether you want to Select objects across schemas or Select objects from Schema in the Object Selection Method list.

   If you choose the Select objects from Schema option, then enter the schema name in the Schema field that appears.

9. If you chose the Select objects across schemas option, then use the Schema list to select the schemas that contain the objects that you want to add to the selected master group.

10. Click OK to add the selected objects to the master group.

11. When adding an object to a master group, you must also consider the following administrative operations:

    • When adding a table, how to configure conflict resolution (Configuring Conflict Resolution) for the table.

    • When adding multiple objects to a group at the same time, Oracle attempts to create dependent objects in the proper order. However, when a group of objects has circular dependencies, you may need to manually precreate object definitions (Replicating Object Definitions to Master Sites) and populate the objects at each master site. In other words, Use Existing Object must be enabled and Copy Row Data must be disabled for the objects.

    • When a table contains a self-referential constraint, you need to precreate the table definition (Replicating Object Definitions to Master Sites) and manually populate the table with data at all master sites. In other words Use Existing Object must be enabled and Copy Row Data must be disabled for the table.

    After you have added objects to a master group and have dealt with the issues listed above, generate replication support for all master group tables (Generating Replication Support for Master Group Objects), 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).

12. In the Objects subpage, under the Generate Replication Support column for the object, select to generate or regenerate replication support for all replicated objects in the currently selected master group.

    If the object does not exist at the other master sites, then the object is created at the other sites regardless of your selection.

    See Replicating Object Definitions to Master Sites for more information.

13. Click Apply.

    Note: Do not explicitly replicate indexes that correspond to PRIMARY KEY and UNIQUE constraints for replicated tables in a master group. Oracle automatically replicates all table constraint definitions, which in turn replicates indexes that are necessary to enforce constraints