Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | SNAPSHOT_REFRESH_GROUP |
| Short Name | SRG |
| View Name | CI_SNAPSHOT_REFRESH_GROUPS |
| Description | A group of snapshots on the same database that are to be refreshed |
| together, either manually and/or automatically at a specified regular | |
| time interval. | |
| Snapshots are now known as 'Materialized Views' | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_SRG |
| Changes: | Summary of changes to SNAPSHOT_REFRESH_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 on one and only one ORACLE_DATABASE | |
| ROLLBACK_SEGMENT_REFERENCE | Y | Prompt: Rollback Segment | May be designated as using one and only one ROLLBACK_SEGMENT | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| IMPLICIT_DESTROY | VARCHAR2(1) | N | Indicates whether refresh group is to be automatically deleted when it no longer contains any members
Prompt: Implicit Destroy ? Uppercase | YESNO | N |
| INTERVAL | VARCHAR2(240) | Y | Function used to calculate the next time to refresh materialized views in the group, used in conjunction with the NEXT_DATE property. For example, NEXT_DAY(SYSDATE + 1, "MONDAY")
Prompt: Interval | ||
| NAME | VARCHAR2(30) | N | Name of the materialized viewrefresh group
Prompt: Name Uppercase | ||
| NEXT_DATE | VARCHAR2(12) | Y | Date on which the next refresh is to occur. Property is defined as varchar2 to allow for values such as 'SYSDATE'
Prompt: Next Date Uppercase | ||
| PUSH_DEFERRED_RPC | VARCHAR2(1) | N | Applicable to updatable materialized views only. Indicates whether changes from the materialized view are to be pushed to its associated master before refreshing the materialized view
Prompt: Push Deferred RPC ? Uppercase | YESNO | Y |
| REFRESH_AFTER_ERRORS | VARCHAR2(1) | N | Applicable to updatable materialized views only. Indicates whether refresh to proceed even if there are outstanding conflicts logged in the DefError table for the materialized view's master
Prompt: Refresh After Errors ? Uppercase | YESNO | N |
| 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 |
|---|
| SNAPSHOT_REFRESH_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:
|
Other element types that reference SNAPSHOT_REFRESH_GROUP:
Note: