Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_OFFLINE_SNAPSHOT.END_LOAD

Purpose

To complete offline instantiation of a snapshot. You must call this procedure from the snapshot site for the new snapshot. For additional information, refer to

Syntax

The parameters for the END_LOAD procedure are described in Table 12 - 50, and the exceptions are listed in Table 12 - 51. The syntax for this procedure is shown below.

DBMS_OFFLINE_SNAPSHOT.END_LOAD(
     gname           IN  VARCHAR2,
     sname           IN  VARCHAR2,
     snapshot_oname  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.
snapshot_oname The name of the snapshot.

Table 12 - 50. Parameters for END_LOAD

Exception Description
23430 badargument Null or empty string for object group, schema, or snapshot name.
missingrepgroup GNAME does not exist as a replicated object group.
nonsnapshot This procedure must be called from the snapshot site.

Table 12 - 51. Exceptions for END_LOAD

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.
`snapshot_oname`	The name of the snapshot.

Exception	Description
23430 badargument	Null or empty string for object group, schema, or snapshot name.
missingrepgroup	GNAME does not exist as a replicated object group.
nonsnapshot	This procedure must be called from the snapshot site.