22
DBMS_OFFLINE_SNAPSHOT

The DBMS_OFFLINE_SNAPSHOT package contains public APIs for offline instantiation of snapshots.

Note:
These procedure are used in performing an offline instantiation of a snapshot.
These procedures 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 usage.

Summary of Subprograms

Table 22-1 DBMS_OFFLINE_SNAPSHOT Package Subprograms

Subprogram	Description
BEGIN_LOAD procedure	Prepares a snapshot site for import of a new snapshot as part of offline instantiation.
END_LOAD procedure	Completes offline instantiation of a snapshot.

BEGIN_LOAD procedure

This procedure prepares 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.

Syntax

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 := '',
   min_communication   IN   BOOLEAN  := TRUE);

Parameters

Table 22-2 BEGIN_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.
master_site	Fully qualified database name of the snapshot's master site.
snapshot_oname	Name of the temporary snapshot created at the master site.
storage_c	Storage options to use when creating the new snapshot at the snapshot site.
comment	User comment.
min_communication	If `TRUE`, then the update trigger sends the new value of a column only if the update statement modifies the column. The update trigger sends the old value of the column only if it is a key column or a column in a modified column group.

Exceptions

Table 22-3 BEGIN_LOAD Procedure Exceptions

Exception	Description
badargument	Null or empty string for object group, schema, master site, or snapshot name.
dbms_repcat. missingrepgroup	`gname` does not exist as a replicated master group.
missingremotesnap	Could not locate given snapshot at given master site.
dbms_repcat. missingschema	Given schema does not exist.
snaptabmismatch	Base table name of the snapshot at the master and snapshot do not match.

END_LOAD procedure

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

Syntax

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

Parameters

Table 22-4 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 22-5 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.

22DBMS_OFFLINE_SNAPSHOT

Summary of Subprograms

Table 22-1 DBMS_OFFLINE_SNAPSHOT Package Subprograms

BEGIN_LOAD procedure

Syntax

Parameters

Table 22-2 BEGIN_LOAD Procedure Parameters

Exceptions

Table 22-3 BEGIN_LOAD Procedure Exceptions

END_LOAD procedure

Syntax

Parameters

Table 22-4 END_LOAD Procedure Parameters

Exceptions

Table 22-5 END_LOAD Procedure Exceptions

22
DBMS_OFFLINE_SNAPSHOT