Oracle7 Server Distributed Systems Volume II: Replicated Data

Creating a Replicated Object Group

Only objects in a replicated object group can be replicated to other master and snapshot sites. When you create a replicated object group, the name of the object group is added to the RepGroup view at that site. Additionally, the object group name and the global database name (and the connection qualifier, if any, associated with the object group for the local site are added to the RepSite view for the site, and by default, this site is designated as the master definition site.

To create a new, empty, quiesced master replicated object group, call DBMS_REPCAT.CREATE_MASTER_REPGROUP, as shown in the following example:

DBMS_REPCAT.CREATE_MASTER_REPGROUP(
    gname          => 'acct',
    group_comment => 'created by '||JSMITH||' on '||1-24-96, 
    master_comment => 'created by '||JSMITH||' on '||1-24-96);

When you create a new replicated object group, you may choose to add a comment to the RepGroup or RepSite views. In this example, the comment indicates when the replicated object group was first created and by whom.

Additional Information: The parameters for the CREATE_MASTER_REPGROUP procedure are described in Table 12 - 100, and the exceptions are listed in Table 12 - 101.