DBA_REGISTERED_MVIEW_GROUPS

DBA_REGISTERED_MVIEW_GROUPS lists all the registered materialized view groups at the master site or master materialized view site.

Column Datatype NULL Description

NAME

VARCHAR2(30)

  

Name of the materialized view replication group

MVIEW_SITE

VARCHAR2(128)

  

Site of the materialized view replication group

GROUP_COMMENT

VARCHAR2(80)

  

Description of the materialized view replication group

VERSION

VARCHAR2(8)

  

Oracle release of the materialized view replication group:

  • ORACLE 7

  • ORACLE 8

  • REPAPI

Note: Oracle8i and newer materialized view groups show ORACLE 8.

FNAME

VARCHAR2(30)

  

Name of the flavor of the materialized view group

OWNER

VARCHAR2(128)

  

Owner of the materialized view replication group