Skip Headers

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)

Part Number A96612-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_OFFLINE_SNAPSHOT, 2 of 2


Summary of DBMS_OFFLINE_SNAPSHOT Subprograms

Table 37-1 DBMS_OFFLINE_SNAPSHOT Package Subprograms
Subprogram Description

BEGIN_LOAD Procedure

Prepares a materialized view site for import of a new materialized view as part of offline instantiation.

END_LOAD Procedure

Completes offline instantiation of a materialized view.

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.


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 37-2 BEGIN_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.

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.

Exceptions

Table 37-3 BEGIN_LOAD Procedure Exceptions
Exception Description

badargument

NULL or empty string for replication group, schema, master site, or materialized view name.

dbms_repcat.missingrepgroup

gname does not exist as a replication group.

missingremotemview

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.


Syntax

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

Parameters

Table 37-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 37-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.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback