Oracle7 Server Distributed Systems Volume II: Replicated Data

Creating a Snapshot Replication Site

This section outlines the procedure that you must perform to create a snapshot site containing updatable snapshots. Each of these steps is described in more detail later in this chapter.

Optionally, you may perform the following step at the master site:

Create a snapshot log for the master table using the CREATE SNAPSHOT LOG command. This allows you to perform fast refreshes of your snapshots. Refer to for information on creating and using snapshot logs.

Perform the following steps at each snapshot site:

Create the necessary snapshots using the FOR UPDATE clause of the CREATE SNAPSHOT command, as described .

Create the necessary links between the snapshot site and its master site, as described .

Create the replicated object group at the snapshot site by calling CREATE_SNAPSHOT_REPGROUP.

Create the replicated objects, including updatable snapshots, at the snapshot site by calling CREATE_SNAPSHOT_REPOBJECT.

This procedure generates the necessary replication support for each object.

Ensure that multiple snapshots will be refreshed to a single point in time by using the DBMS_REFRESH.MAKE procedure to maintain transactional consistency and preserve master detail relationships.