Element Type Definition: REPLICATION

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	REPLICATION_GROUP
Short Name	RPG
View Name	CI_REPLICATION_GROUPS
Description	A set of database objects, implemented on a specific database
	(known as the "master site"), that are to be replicated on one
	or more other databases.

	The database objects in the replication group may be implemented
	in the same schema or different schemas, but all such schemas must
	be for users at the same "master site" database.

	The database(s) to which changes to the database objects in the
	replication group at the "master site" are to be propagated, are
	defined by the associated REPLICATION_GROUP_PROPAGATIONS.

Sub-type of	SECONDARY_ACCESS_ELEMENT
Versioning:	Belongs to: ORACLE_DATABASE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	ORACLE_DATABASE_REFERENCE NAME
Used by:	Oracle Designer
Underlying table:	SDD_RPG
Changes:	Summary of changes to REPLICATION_GROUP in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ORACLE_DATABASE_REFERENCE	N	Prompt: Oracle Database Transferable only if null	Must be administered at one and only one ORACLE_DATABASE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
NAME	VARCHAR2(30)	N	Name of this object group Prompt: Name Uppercase
REMARK	VARCHAR2(2000)	Y	A brief comment on the replication group Prompt: Comment
PARENT_IVID	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs Not displayed System maintained Updatable only if null Defined on SAC supertype
PAC_REFERENCE	NUMBER(38, 0)	Y	Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs Not displayed System maintained Not updatable by user Defined on SAC supertype

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

Other Properties
REPLICATION_GROUP has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference REPLICATION_GROUP:

Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each JAVA_MOD_IMPLEMENTATION may be in one and only one REPLICATION_GROUP
Each PLSQL_MOD_IMPLEMENTATION may be in one and only one REPLICATION_GROUP
Each REPGROUP_PROPAGATION must be for one and only one REPLICATION_GROUP
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
Each TABLE_IMPLEMENTATION may be in one and only one REPLICATION_GROUP
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT
Each VIEW_IMPLEMENTATION may be in one and only one REPLICATION_GROUP

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype