END_LOAD procedure

This procedure completes offline instantiation of a snapshot. You must call this procedure from the snapshot site for the new snapshot.

Note: This procedure is used in performing an offline instantiation of a snapshot. This procedure should not be confused with the procedures in the DBMS_OFFLINE_OG package (used for performing an offline instantiation of a master table) or with the procedures in the DBMS_REPCAT_INSTANTIATE package (used for instantiating a deployment template). See these respective packages for more information on their use.

Syntax

DBMS_OFFLINE_SNAPSHOT.END_LOAD (
   gname           IN  VARCHAR2,
   sname           IN  VARCHAR2,
   snapshot_oname  IN  VARCHAR2);

Parameters

Table 8-67 END_LOAD Procedure Parameters

Parameter	Description
gname	Name of the object group for the snapshot that you are creating using offline instantiation.
sname	Name of the schema for the new snapshot.
snapshot_oname	Name of the snapshot.

Exceptions

Table 8-68 END_LOAD Procedure Exceptions

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