Oracle7 Server Distributed Systems Volume II: Replicated Data

Creating the Replicated Object Group

Create a new empty snapshot replicated object group in your local database by calling the CREATE_SNAPSHOT_REPGROUP procedure in the DBMS_REPCAT package, as shown in the following example:

DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP(
    gname            => 'accts', 
    master           => 'acct_hq.hq.com', 
    comment          => 'created on ...',
    propagation_mode => 'asynchronous');

Attention: Notice that the replicated object group name must match the master group name.

In this example, the ACCTS object group is created in the current database. When you add replicated objects to this object group by calling CREATE_SNAPSHOT_REPOBJECT, they will be refreshed using the ACCT_HQ database as their master. Changes from the snapshot site will be asynchronously propagated to its associated master site as described .

Because each snapshot site may contain a different subset of the objects at its associated master site, there is no snapshot equivalent to the DBMS_REPCAT.ADD_MASTER_DATABASE procedure. If you will be creating multiple snapshot sites with similar members, you may want to create them using a script, which can be modified and re-executed at each site.

Additional Information: The parameters for the CREATE_SNAPSHOT_REPGROUP procedure are described in Table 12 - 105, and the procedures are listed in Table 12 - 106.