Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | CLUSTER |
| Short Name | OCL |
| View Name | CI_CLUSTERS |
| Description | Definition of a cluster, allowing the data in one or more tables to be |
| structured so that the columns are physically close to one another on | |
| the Oracle database | |
| Sub-type of | SHAREABLE_ELEMENT |
| Versioning: | Structure of CLUSTER versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_OCL |
| Changes: | Summary of changes to CLUSTER in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| CLUSTER_SIZE | NUMBER(38, 0) | Y | The estimate of the number of bytes a cluster key and rows will occupy.
Prompt: Size | ||
| CLUSTER_TYPE | VARCHAR2(3) | N | Indicates whether the cluster is an index cluster or a hash cluster
Prompt: Type Uppercase | CLUSTER_TYPE | ICL |
| HASHKEYS | NUMBER(10, 0) | Y | Number of hash values for a hash cluster. Must be >= 2
Prompt: Hashkeys | ||
| HASH_IS | VARCHAR2(100) | Y | Expression to be used as the 'hash is' function. Free format text
Prompt: Hash Is | ||
| NAME | VARCHAR2(30) | N | The name of the cluster.
Prompt: Name Uppercase | ||
| REMARK | VARCHAR2(2000) | Y | A comment on the cluster.
Prompt: Comment | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| CLUSTER 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:
Note: