Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to current chapter
Up
Go to next page
Next
View PDF

REGISTER_MVIEW_REPGROUP Procedure

This procedure facilitates the administration of materialized views at their respective master sites or master materialized view sites by inserting or modifying a materialized view group in DBA_REGISTERED_MVIEW_GROUPS.

Syntax

DBMS_REPCAT.REGISTER_MVIEW_REPGROUP (
   gname            IN   VARCHAR2,
   mviewsite        IN   VARCHAR2,
   comment          IN   VARCHAR2  := NULL,
   rep_type         IN   NUMBER    := reg_unknown,
   fname            IN   VARCHAR2  := NULL,
   gowner           IN   VARCHAR2  := 'PUBLIC');

Parameters

Table 18-110 REGISTER_MVIEW_REPGROUP Procedure Parameters  
Parameter Description
gname

Name of the materialized view group to be registered.

mviewsite

Global name of the materialized view site.

comment

Comment for the materialized view site or update for an existing comment.

rep_type

Version of the materialized view group. Valid constants that can be assigned include the following:

  • dbms_repcat.reg_unknown (the default)
  • dbms_repcat.reg_v7_group
  • dbms_repcat.reg_v8_group
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 18-111 REGISTER_MVIEW_REPGROUP Procedure Exceptions  
Exception Description
failregmviewrepgroup

Registration of materialized view group failed.

missingrepgroup

Replication group name not specified.

nullsitename

A materialized view site was not specified.

nonmaster

Procedure must be executed at the materialized view's master site or master materialized view site.

duplicaterepgroup

Replication group already exists.