Data Dictionary Views, 28 of 112

Oracle8i Replication Management API Reference
Release 2 (8.1.6)
Part Number A76958-01

Data Dictionary Views, 28 of 112

ALL_REPSITES

Lists the members of each replicated object group accessible to the current user.

Related views:

DBA_REPSITES lists the members of each replicated object group in the database.

USER_REPSITES lists the members of each replicated object group owned by the current user.

Column Datatype NULL Description

GNAME

VARCHAR2(30)

NOT NULL

The name of the replicated object group.

DBLINK

VARCHAR2(128)

NOT NULL

The database link to a master site for this object group.

MASTERDEF

VARCHAR2(1)

Indicates which of the DBLINKs is the master definition site.

SNAPMASTER

VARCHAR2(1)

Used by snapshot 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:

PROP_UPDATES

NUMBER

Encoding of propagating technique for master.

MY_DBLINK

VARCHAR2(1)

Used to detect problems after import. If Y then the DBLINK is the global name.

Oracle

Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.