Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | LOB_STORAGE |
| Short Name | LST |
| View Name | CI_LOB_STORAGES |
| Description | A LOB_STORAGE represents a specification of storage information for |
| a LOB and its index that is able to be used by one or more LOB columns | |
| within the same database | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
ORACLE_DATABASE_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_LST |
| Changes: | Summary of changes to LOB_STORAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ORACLE_DATABASE_REFERENCE | N |
Prompt: Oracle Database
Transferable only if null |
Must be defined in one and only one ORACLE_DATABASE | |
| INDEX_STORAGE_DEFN_REFERENCE | Y | Prompt: Storage Definition (Index) | May be with LOB index limited by one and only one STORAGE_DEFINITION | |
| INDEX_TABLESPACE_REFERENCE | Y | Prompt: Tablespace (Index) | May be with LOB index created in one and only one TABLESPACE | |
| 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 |
| CACHE_FLAG | VARCHAR2(1) | N | Indicates whether CACHE option is required (ie blocks retrieved placed at most recently used end or least recently used end of the LRU in the buffer cache when a full table scan is performed)
Prompt: Cache ? Uppercase | YESNO | N |
| CHUNK | NUMBER(38, 0) | Y | The unit of LOB value allocation and manipulation. Expressed in units indicated by CHUNK_UNIT
Prompt: Chunk Range: 1 to 99999999999999999999999999999999999999 | ||
| CHUNK_UNIT | VARCHAR2(1) | Y | Unit of measure in which the CHUNK property is expressed
Prompt: Chunk Unit Uppercase | OGO_UNITS_OF_QUOTA | |
| INDEX_INITIAL_TRANSACTION | NUMBER(3, 0) | Y | Initial number of transaction entries allocated within each data block allocated to the LOB index segment
Prompt: Init Trans (Index) Range: 1 to 999 | ||
| INDEX_MAXIMUM_TRANSACTION | NUMBER(3, 0) | Y | Maximum number of concurrent transactions that can update a data block allocated to the LOB index segment
Prompt: Max Trans (Index) Range: 1 to 999 | ||
| LOGGING_FLAG | VARCHAR2(1) | N | Indicates whether LOGGING option is required (ie whether subsequent operations against the LOB storage that can execute without logging are to be logged in the redo file)
Prompt: Logging ? Uppercase | YESNO | Y |
| NAME | VARCHAR2(30) | N | Name by which the LOB storage is identified. (Note that this is distinct from the LOB segment name which is held on COLUMN_LOB_STORAGE)
Prompt: Name Uppercase | ||
| PCTVERSION | NUMBER(2, 0) | Y | Maximum percentage of overall LOB storage space used for creating new versions of the LOB, ie older versions of the LOB data are not overwritten until this percentage of the overall LOB storage space is used
Prompt: Percent Version 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 |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| LOB_STORAGE 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 LOB_STORAGE:
Note: