Element Type Definition: SNAPSHOT

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	SNAPSHOT_IMPLEMENTATION
Short Name	SNI
View Name	CI_SNAPSHOT_IMPLEMENTATIONS
Description	The implementation of a snapshot in a specific schema.

	Snapshots are now known as 'Materialized Views'

Sub-type of	DB_OBJECT_IMPLEMENTATION
Versioning:	Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	DATABASE_USER_REFERENCE SNAPSHOT_DEFINITION_REFERENCE
Used by:	Oracle Designer
Underlying table:	SDD_DOI
Changes:	Summary of changes to SNAPSHOT_IMPLEMENTATION in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
DATABASE_USER_REFERENCE	N	Prompt: Database User Transferable only if null Defined on DOI supertype	Must be in schema of one and only one DATABASE_USER
SNAPSHOT_DEFINITION_REFERENCE	N	Prompt: Materialized View Transferable only if null	Must be an implementation of one and only one SNAPSHOT_DEFINITION
SNAPSHOT_GROUP_REFERENCE	Y	Prompt: Materialized View Group	May be a member in one and only one SNAPSHOT_REFRESH_GROUP
STORAGE_DEFINITION_REFERENCE	Y	Prompt: Storage Definition	May be limited by one and only one STORAGE_DEFINITION
TABLESPACE_REFERENCE	Y	Prompt: Tablespace	May be created in one and only one TABLESPACE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
BUILD_TYPE	VARCHAR2(9)	Y	Indicates when the materialized view is to be populated after executing the DDL Prompt: Build Type Uppercase	BUILD_TYPE
CACHED	VARCHAR2(1)	Y	Indicates if the materialized view is cached Prompt: Cached Uppercase	CACHED
COMPLETE_FLAG	VARCHAR2(1)	N	Indicates whether the definition of the database object is complete and ready to be used by the generators Prompt: Complete ? Uppercase Defined on DOI supertype	YESNO	Y
GLOBAL_SYNONYM_NAME	VARCHAR2(30)	Y	Name to be used by Server Generator when creating synonyms for this object Prompt: Global Synonym Name Uppercase
INITIAL_TRANSACTION	NUMBER(3, 0)	Y	Initial number of transaction entries that are allocated within each block in this materialized view Prompt: Init Trans Range: 1 to 255
MAXIMUM_TRANSACTION	NUMBER(3, 0)	Y	The maximum number of transactions that may update a block concurrently. Prompt: Max Trans Range: 1 to 255
OBJECT_IMPLEMENTATION_TYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal property indicating whether the DB_OBJECT_IMPLEMENTATION is a TABLE_IMPLEMENTATION (TBI), VIEW_IMPLEMENTATION (VWI), SNAPSHOT_IMPLEMENTATION (SNI), SEQUENCE_IMPLEMENTATION (SQI) etc Not displayed Uppercase System maintained Not updatable by user Defined on DOI supertype	OBJECT_IMPLEMENTATION_TYPE
PERCENT_FREE	NUMBER(3, 0)	Y	Amount of free space (as a percentage) in a block thhat is allocated to this materialized view for future updates to the data. Prompt: Percent Free Range: 0 to 99
PERCENT_USED	NUMBER(3, 0)	Y	Minimum level of space (as a percentage) in a block that ORACLE maintains for each block. Prompt: Percent Used Range: 1 to 99
QUERY_REWRITE_INDICATOR	VARCHAR2(8)	Y	Indicates whether materialized view is eligible to be used for query rewrite Prompt: Query Rewrite ? Uppercase	QUERY_REWRITE_IND
REFRESH_NEXT	VARCHAR2(240)	Y	The NEXT component of the refresh clause. Prompt: Next Refresh Clause
REFRESH_START	VARCHAR2(120)	Y	The start date and time of the refresh clause. Prompt: Refresh Start Time
REFRESH_TYPE	VARCHAR2(8)	Y	Specifies how ORACLE refreshes the materialized view Prompt: Refresh Type Uppercase	REFRESH_TYPE
SCOPE	VARCHAR2(8)	N	Scope of visibility of the database object, used by the Server Generator to determine when database links and synonyms need to be created Prompt: Scope Uppercase	DB_OBJECT_SCOPE	DATABASE
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
IMPLEMENTATION_DESCRIPTION	IMPDSC Defined on DOI supertype	Implementation Description
IMPLEMENTATION_NOTES	IMPNOT Defined on DOI supertype	Implementation Notes
NON_ORACLE_DATABASE_STORAGE	STODSC	Non-Oracle Storage

Other Properties
SNAPSHOT_IMPLEMENTATION 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_IMPLEMENTATION:

Each BASE_RELATION_LOCATION must be for one and only one SNAPSHOT_IMPLEMENTATION (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_OBJECT_GRANT must be for one and only one SNAPSHOT_IMPLEMENTATION (in arc)
Each INDEX_STORAGE must be for an index on one and only one SNAPSHOT_IMPLEMENTATION (in arc)
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
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

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