Element Type Definition: SNAPSHOT

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	SNAPSHOT_DEFINITION
Short Name	SNP
View Name	CI_SNAPSHOT_DEFINITIONS
Description	Definition of a snapshot, ie of a full copy of a table or subset of a
	that reflects a recent state of the master table

	Snapshots are now known as 'Materialized Views'

Sub-type of	RELATION_DEFINITION
Versioning:	Structure of SNAPSHOT_DEFINITION versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_TAB
Changes:	Summary of changes to SNAPSHOT_DEFINITION in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
CLUSTER_REFERENCE	Y	Prompt: Cluster	May be optimised for access by one and only one CLUSTER

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
ALIAS	VARCHAR2(10)	Y	The unique alias for the materialized view name Prompt: Alias Uppercase
DISPLAY_TITLE	VARCHAR2(132)	Y	The title of this materialized view to be used in screens, reports etc. Prompt: Display Title
NAME	VARCHAR2(30)	N	The unique table name. Prompt: Name Uppercase Defined on TAB supertype
OVERRIDE_SELECT_TEXT_FLAG	VARCHAR2(1)	N	Indicates whether (Y) or not (N) the SELECT information is to be free format Prompt: Free Format Select Text ? Uppercase	YESNO	N
REMARK	VARCHAR2(2000)	Y	A brief comment about this table, view, snapshot or record Prompt: Comment Defined on TAB supertype
TABLE_TYPE	VARCHAR2(6)	Y	Sub-type discriminator. Internal property indicating whether the RELATION_DEFINITION is a TABLE_DEFINITION (TABLE), VIEW_DEFINITION (VIEW), RECORD (RECORD), or SNAPSHOT_DEFINITION (SNAP). Not displayed Uppercase System maintained Not updatable by user Defined on TAB supertype	TAB_TABLE_TYPE
UPDATABLE_FLAG	VARCHAR2(1)	N	Indicates whether the materialized view is updatable Prompt: Updatable ? Uppercase	YESNO	N

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
EXPRESSION	LGEXPR	Select Text
HELP	CDHELP	User/Help Text
NOTES	CDINOT	Notes
OPTIMIZER_HINT	DBHINT	Optimizer Hint Clause
WHERE_CLAUSE	CDWHCL	Where/Validation Condition

Other Properties
SNAPSHOT_DEFINITION 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 SNAPSHOT_DEFINITION:

Each ASSUMPTION_TO_TABLE must be a use for one and only one RELATION_DEFINITION
Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each COLUMN must be of one and only one RELATION_DEFINITION (in arc)
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 DATABASE_SYNONYM must be for one and only one SNAPSHOT_DEFINITION (in arc)
Each JOIN_CONSTRAINT must be for joining to one and only one RELATION_DEFINITION
Each MODULE_DETAIL_TABLE_USAGE must be of one and only one RELATION_DEFINITION
Each CONSTRAINT must be placed on one and only one RELATION_DEFINITION
Each RELATION_INDEX must be to optimise access to one and only one SNAPSHOT_DEFINITION (in arc)
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each SNAPSHOT_IMPLEMENTATION must be an implementation of one and only one SNAPSHOT_DEFINITION
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
Each TABLE_ENTITY must be by one and only one RELATION_DEFINITION
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 RELATION_SELECTION must be in one and only one RELATION_DEFINITION
Each RELATION_SELECTION must be of one and only one RELATION_DEFINITION

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