Oracle Tips by Burleson

dba_repgroup views

DBA_REPGROUP
Information about all replicated object groups
------------------------------------------------------------------------------------
SNAME 			VARCHAR2 	OBSOLETE COLUMN: Name of the replicated schema
MASTER 			VARCHAR2 	Is the site a master site for the replicated object group
STATUS 			VARCHAR2 	If the site is a master, the master's status
SCHEMA_COMMENT 		VARCHAR2 	Description of the replicated object group
GNAME 			VARCHAR2 	Name of the replicated object group
FNAME 			VARCHAR2 	Flavor name
RPC_PROCESSING_DISABLED 	VARCHAR2
OWNER 			VARCHAR2 	Owner of the replicated object group


DBA_REPGROUPED_COLUMN
Columns in the all column groups of replicated tables in the database
------------------------------------------------------------------------------------
SNAME 			VARCHAR2 	Owner of replicated object
ONAME 			VARCHAR2 	Name of the replicated object
GROUP_NAME 		VARCHAR2 	Name of the column group
COLUMN_NAME 		VARCHAR2 	Name of the column in the column group


DBA_REPGROUP_PRIVILEGES
Information about users who are registered for object group privileges
------------------------------------------------------------------------------------
USERNAME 			VARCHAR2 	Name of the user
GNAME 			VARCHAR2 	Name of the replicated object group
CREATED 			DATE 	Registration date
RECEIVER 			VARCHAR2 	Receiver privileges
PROXY_SNAPADMIN 		VARCHAR2 	Proxy snapadmin privileges
OWNER 			VARCHAR2 	Owner of the replicated object group