Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
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_REPCAT, 27 of 69


CREATE_MVIEW_REPGROUP Procedure

This procedure creates a new, empty materialized view group in your local database. CREATE_MVIEW_REPGROUP automatically calls REGISTER_MIEW_REPGROUP, but ignores any errors that may have happened during registration.

Syntax

DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
   gname              IN   VARCHAR2, 
   master             IN   VARCHAR2, 
   comment            IN   VARCHAR2     := '',
   propagation_mode   IN   VARCHAR2     := 'ASYNCHRONOUS',
   fname              IN   VARCHAR2     := NULL
      gowner             IN   VARCHAR2     := 'PUBLIC');

Parameters

Table 48-55 CREATE_MVIEW_REPGROUP Procedure Parameters
Parameter  Description 
gname
 

Name of the replication group. This group must exist at the specified master site or master materialized view site. 

master
 

Fully qualified database name of the database in the replication environment to use as the master site or master materialized view site. You can include a connection qualifier if necessary. See Oracle9i Replication and Oracle9i Database Administrator's Guide for information about using connection qualifiers. 

comment
 

This comment is added to the DBA_REPGROUP view. 

propagation_mode
 

Method of propagation for all updatable materialized views in the replication group. Acceptable values are synchronous and asynchronous

fname
 

This parameter is for internal use only.

Note: Do not set this parameter unless directed to do so by Oracle Support Services. 

gowner
 

Owner of the materialized view group. 

Exceptions

Table 48-56 CREATE_MVIEW_REPGROUP Procedure Exceptions
Exception  Description 
duplicaterepgroup
 

Replication group already exists at the invocation site. 

nonmaster
 

Specified database is not a master site or master materialized view site. 

commfailure
 

Specified database is not accessible. 

norepopt
 

Advanced replication option is not installed. 

typefailure
 

Propagation mode was specified incorrectly. 

missingrepgroup
 

Replication group does not exist at master site. 

invalidqualifier
 

Connection qualifier specified for the master site or master materialized view site is not valid for the replication group. 

alreadymastered
 

At the local site, there is another materialized view group with the same group name, but different master site or master materialized view site. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, 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