Oracle Tips by Burleson

dba_repsites

DBA_REPSITES
N-way replication information
------------------------------------------------------------------------------------
GNAME 		VARCHAR2 	Name of the replicated object group
DBLINK 		VARCHAR2 	A database site replicating the schema
MASTERDEF 		VARCHAR2 	Is the database the master definition site for the replicated object group
SNAPMASTER 	VARCHAR2 	For a snapshot site, is the database the current refresh master
MASTER_COMMENT 	VARCHAR2 	Description of the database site
MASTER 		VARCHAR2 	Redundant information from dba_repcat.master
PROP_UPDATES 	NUMBER 	Number of requested updates for master in repcat$_repprop
MY_DBLINK 		VARCHAR2 	A sanity check after import: is this master the current site
GROUP_OWNER 	VARCHAR2 	Owner of the replicated object group


DBA_REPSITES_NEW
Information about new masters for replication extension
------------------------------------------------------------------------------------
EXTENSION_ID 	RAW 	Globally unique identifier for replication extension
GOWNER 		VARCHAR2 	Owner of the object group
GNAME 		VARCHAR2 	Name of the replicated object group
DBLINK 		VARCHAR2 	A database site that will replicate the object group
FULL_INSTANTIATION 	VARCHAR2 	Y if the database uses full-database export or change-based recovery
MASTER_STATUS 	VARCHAR2 	Instantiation status of the new master