ALL_REPSITES

Lists the members of each replication group accessible to the current user.

Related Views:

• DBA_REPSITES lists the members of each replication group in the database.
• USER_REPSITES lists the members of each replication group owned by the current user.

  Column	Datatype	NULL	Description
  GNAME	VARCHAR2(30)	NOT NULL	The name of the replication group.
  DBLINK	VARCHAR2(128)	NOT NULL	The database link to a master site for this replication group.
  MASTERDEF	VARCHAR2(1)	-	Indicates which of the DBLINKs is the master definition site.
  SNAPMASTER	VARCHAR2(1)	-	Used by materialized view sites to indicate which of the DBLINKs to use when refreshing.
  MASTER_COMMENT	VARCHAR2(80)	-	User-supplied comments.
  MASTER	VARCHAR2(1)	-	If Y then the site is a master site for the replicated group. If N then the site is not a master site for the replicated group.
  GROUP_OWNER	VARCHAR2(30)	NOT NULL	Owner of the replication group.

The DBA_REPSITES view has the following additional columns:

Column	Datatype	NULL	Description
PROP_UPDATES	NUMBER	-	Encoding of propagating technique for master site.
MY_DBLINK	VARCHAR2(1)	-	Used to detect problems after import. If Y then the DBLINK is the global name.