Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | CLUSTER_IMPLEMENTATION |
| Short Name | CLI |
| View Name | CI_CLUSTER_IMPLEMENTATIONS |
| Description | The implementation of a cluster in a specific schema. |
| 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 CLUSTER_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DOI |
| Changes: | Summary of changes to CLUSTER_IMPLEMENTATION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| CLUSTER_REFERENCE | N |
Prompt: Cluster
Transferable only if null |
Must be an implementation of one and only one CLUSTER | |
| 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 | |
| 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 |
| CACHED | VARCHAR2(1) | Y | Indicates if this implementation of the cluster is to be 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 |
| DEGREE | NUMBER(6, 0) | Y | Specifies the degree of parallelism. (Property was called MAX_SCANS prior to release 2)
Prompt: Degree Range: 0 to 999999 | ||
| INITIAL_TRANSACTION | NUMBER(3, 0) | Y | Initial number of concurrent update transactions allocated for blocks belonging to the cluster
Prompt: Init Trans Range: 1 to 255 | ||
| INSTANCES | NUMBER(6, 0) | Y | Specifies how cluster is to be split between instances in parallel server
Prompt: Instances Range: 0 to 999999 | ||
| MAXIMUM_TRANSACTION | NUMBER(3, 0) | Y | Maximum number of concurrent update transactions for any given block in cluster
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 | |
| PARALLEL | VARCHAR2(1) | N | Indicates if parallel querying is to be used
Prompt: Parallel ? Uppercase | YESNO | N |
| PERCENT_FREE | NUMBER(3, 0) | Y | The percentage of space to allow for growth of clustered tables
Prompt: Percent Free Range: 0 to 99 | ||
| PERCENT_USED | NUMBER(3, 0) | Y | The percentage of space (free) at which blocks are reused for insert
Prompt: Percent Used Range: 1 to 99 | ||
| 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 |
|---|
| CLUSTER_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:
|
Other element types that reference CLUSTER_IMPLEMENTATION:
Note: