These procedure are used in performing 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.

BEGIN_LOAD Procedure

This procedure prepares a materialized view site for import of a new materialized view as part of offline instantiation. 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.

Parameters

Table 17-2 BEGIN_LOAD Procedure Parameters

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.

master_site

Fully qualified database name of the materialized view's master site.

snapshot_oname

Name of the temporary materialized view created at the master site.

storage_c

Storage options to use when creating the new materialized view at the materialized view 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. Also, if true, 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.

Could not locate specified materialized view at specified master site.

dbms_repcat.missingschema

Specified schema does not exist.

mviewtabmismatch

Base table name of the materialized view at the master and materialized view do not match.

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.