END_LOAD Procedure

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

Note: This procedure is used to perform an offline instantiation of a materialized view. 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.

Syntax

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

Parameters

Table 33-4 END_LOAD Procedure Parameters

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

Exceptions

Table 33-5 END_LOAD Procedure Exceptions

Exception	Description
badargument	NULL or empty string for replication group, schema, or materialized view name.
dbms_repcat.missingrepgroup	gname does not exist as a replication group.
dbms_repcat.nonmview	This procedure must be called from the materialized view site.