Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD

Purpose

To prepare a snapshot site for import of a new snapshot as part of offline instantiation. You must call this procedure from the snapshot site for the new snapshot. For additional information, refer to [*].

Syntax

The parameters for the BEGIN_LOAD procedure are described in Table 12 - 48, and the exceptions are listed in Table 12 - 49. The syntax for this procedure is shown below.

DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD(
     gname           IN  VARCHAR2,
     sname           IN  VARCHAR2,
     master_site     IN  VARCHAR2,
     snapshot_oname  IN  VARCHAR2,
     storage_c       IN  VARCHAR2 := '',
     comment         IN  VARCHAR2 :='')

Parameter Description
gname The name of the object group for the snapshot that you are creating using offline instantiation.
sname The name of the schema for the new snapshot.
master_site The fully qualified database name of the snapshot's master site.
snapshot_oname The name of the temporary snapshot created at the master site.
storage_c The storage options to use when creating the new snapshot at the snapshot site.
comment User comment.
Table 12 - 48. Parameters for BEGIN_LOAD

Exception Description
23430 badargument Null or empty string for object group, schema, master site, or snapshot name.
missingrepgroup GNAME does not exist as a replicated object group.
missingremotesnap Could not locate given snapshot at given master site.
snaptabmismatch Base table name at snapshot site and master site must be identical.
missingschema The given schema does not exist.
Table 12 - 49. Exceptions for BEGIN_LOAD

Contents Index Home Previous Next