Opening the Create Master Group Wizard

Each master site in a replication environment maintains a complete copy of all objects in a replication group. A replication group at a master site is more specifically referred to as a master group. Oracle Enterprise Manager has many features that let you create and manage master groups.

Whether you want to build a multimaster or materialized view replication environment, you need to build at least one master site. Before you create your master group, be sure that you have set up your master sites to support replication.

See Setting Up Master Sites for details.

Also, make sure the schemas whose database objects you want to include in the master group exist at each master site that will participate in the replication activity for the group. If the schemas do not exist at a site, then create them before you complete create the master group.

See Create Schemas at Master Sites for details.

By using the Create Master Group Wizard, you can quickly create a master group. Run the Wizard as follows:

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 Setup. The Advanced Replication: Setup page appears.

4. Expand Multi-master Replication, and select Create Master Group.

5. Click Continue to start the Create Master Group Wizard.

Complete the pages in the wizard. For more information about using the wizard, click Help for each page of the wizard.

During the creation of the master group, the Wizard may prompt you for additional information. For example, when you create a new master group along with a replicated table that does not have a primary key, Oracle Enterprise Manager displays the Set Alternate Key Columns dialog box so that you can identify an alternate identity column or set of columns for the replicated table. The Wizard also asks you whether you want to enable replication activity for the new master group after creation.