Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | STORAGE_DEFINITION |
| Short Name | OSP |
| View Name | CI_STORAGE_DEFINITIONS |
| Description | A physical storage definition that can be associated with database |
| objects, eg tablespaces, rollback segments, table implementations, | |
| indexes | |
| Sub-type of | SHAREABLE_ELEMENT |
| Versioning: | Structure of STORAGE_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_OSP |
| Changes: | Summary of changes to STORAGE_DEFINITION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| FREELISTS | NUMBER(6, 0) | Y | Specifies the number of free lists for each of the free list groups for the table, cluster or index.
Prompt: Freelists Range: 1 to 999999 | ||
| FREELIST_GROUPS | NUMBER(6, 0) | Y | Number of groups of free lists for a table, cluster or index
Prompt: Freelist Groups Range: 1 to 999999 | ||
| INITIAL_EXTENT | NUMBER(38, 0) | Y | The size in bytes of the first extent that will be allocated when the database object is created.
Prompt: Initial Extent Range: 0 to 99999999999999999999999999999999999999 | ||
| INITIAL_EXTENT_UNIT | VARCHAR2(1) | Y | Units (K or M) in which INITIAL_EXTENT is expressed. A null value indicates no unit, ie the values are expressed in bytes
Prompt: Initial Extent Unit Uppercase | OGO_UNITS_OF_QUOTA | |
| MAXIMUM_EXTENTS | NUMBER(38, 0) | Y | The total number of extents that can be allocated.
Prompt: Max Extents Range: 0 to 99999999999999999999999999999999999999 | ||
| MINIMUM_EXTENTS | NUMBER(38, 0) | Y | The initial number of extents to be allocated.
Prompt: Min Extents Range: 0 to 99999999999999999999999999999999999999 | ||
| NAME | VARCHAR2(30) | N | The name of this storage definition.
Prompt: Storage Label Uppercase | ||
| NEXT_EXTENT | NUMBER(38, 0) | Y | The size in bytes of every subsequent extent to be allocated.
Prompt: Next Extent Range: 0 to 99999999999999999999999999999999999999 | ||
| NEXT_EXTENT_UNIT | VARCHAR2(1) | Y | Units (K or M) in which NEXT_EXTENT is expressed. A null value indicates no unit, ie the values are expressed in bytes
Prompt: Next Extent Unit Uppercase | OGO_UNITS_OF_QUOTA | |
| PCT_INCREASE | NUMBER(38, 0) | Y | The percentage by which each following extent will grow.
Prompt: Percentage Increase Range: 0 to 99999999999999999999999999999999999999 | ||
| REMARK | VARCHAR2(240) | Y | A comment on this storage definition.
Prompt: Comment | ||
| UNLIMITED_FLAG | VARCHAR2(1) | N | A value of Y indicates extents should be automatically allocated as needed. If set, MAXIMUM_EXTENTS must be null
Prompt: Unlimited ? Uppercase | YESNO | N |
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| STORAGE_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:
|
Other element types that reference STORAGE_DEFINITION:
Note: