Data Dictionary Views, 15 of 112

ALL_REPGROUP

Describes all of the object groups accessible to the current user that are being replicated. The members of each object group are listed in a different view: ALL_REPOBJECT.

Related views:

DBA_REPGROUP describes all of the object groups in the database that are being replicated.

USER_REPGROUP describes all of the object groups owned by the current user that are being replicated.

Column Datatype NULL Description

SNAME

VARCHAR2(30)

NOT NULL

The name of the replicated schema. Obsolete with release 7.3 or later.

MASTER

VARCHAR2(1)

Y indicates that the current site is a master site.
N indicates the current site is a snapshot site.

STATUS

VARCHAR2(9)

Used at master sites only. Status can be: normal, quiescing, or quiesced.

SCHEMA_COMMENT

VARCHAR2(80)

Any user-supplied comments.

GNAME

VARCHAR2(30)

NOT NULL

The name of the replicated object group.

FNAME

VARCHAR2(30)

Flavor name.

RPC_PROCESSING_DISABLED

VARCHAR2(1)

N indicates that this site can receive and apply deferred RPCs.
Y indicates that this site can NOT receive and apply deferred RPCs.

OWNER

VARCHAR2(30)

NOT NULL

Owner of the replication group.

Column	Datatype	NULL	Description
`SNAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the replicated schema. Obsolete with release 7.3 or later.
`MASTER`	`VARCHAR2(1)`		Y indicates that the current site is a master site. N indicates the current site is a snapshot site.
`STATUS`	`VARCHAR2(9)`		Used at master sites only. Status can be: normal, quiescing, or quiesced.
`SCHEMA_COMMENT`	`VARCHAR2(80)`		Any user-supplied comments.
`GNAME`	`VARCHAR2(30)`	`NOT NULL`	The name of the replicated object group.
`FNAME`	`VARCHAR2(30)`		Flavor name.
`RPC_PROCESSING_DISABLED`	`VARCHAR2(1)`		N indicates that this site can receive and apply deferred RPCs. Y indicates that this site can NOT receive and apply deferred RPCs.
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the replication group.