Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | LOCAL_INDEX_PARTITION |
| Short Name | LIP |
| View Name | CI_LOCAL_INDEX_PARTITIONS |
| Description | A partition of a local index. |
| The partitions of a local index mirror the structure of the partitions | |
| of the table to which the index belongs, and are subject to the same | |
| partition key as the table. | |
| The local index partitions can however have different physical | |
| characteristics to their table partition counterparts such as | |
| different storage definitions and be stored in different tablespaces. | |
| A new capability in Oracle8 | |
| Sub-type of | INDEX_PARTITION |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_PARTITION_REFERENCE INDEX_STORAGE_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_INP |
| Changes: | Summary of changes to LOCAL_INDEX_PARTITION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| INDEX_STORAGE_REFERENCE | N |
Prompt: Index
Transferable only if null Defined on INP supertype |
Must be a partition of one and only one INDEX_STORAGE | |
| TABLE_PARTITION_REFERENCE | N | Prompt: Table Partition | Must be related to one and only one TABLE_PARTITION | |
| STORAGE_DEFINITION_REFERENCE | Y |
Prompt: Storage Definition
Defined on INP supertype |
May be limited by one and only one STORAGE_DEFINITION | |
| TABLESPACE_REFERENCE | Y |
Prompt: Tablespace
Defined on INP supertype |
May be located in one and only one TABLESPACE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| INDEX_PARTITION_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the INDEX_PARTITION is a GLOBAL_INDEX_PARTITION (GIP) or a LOCAL_INDEX_PARTITION (LIP)
Not displayed Uppercase System maintained Not updatable by user Defined on INP supertype | INDEX_PARTITION_TYPE | |
| INITIAL_TRANSACTION | NUMBER(3, 0) | Y | Initial number of transaction entries allocated within each data block allocated to the partition
Prompt: Init Trans Defined on INP supertype | ||
| MAXIMUM_TRANSACTION | NUMBER(3, 0) | Y | Maximum number of concurrent transactions that can update a data block allocated to the partition
Prompt: Max Trans Defined on INP supertype | ||
| NAME | VARCHAR2(30) | N | Name of the index partition
Prompt: Name Uppercase System maintained: API provides a value only if left null by the user Defined on INP supertype | ||
| PERCENT_FREE | NUMBER(3, 0) | Y | Percentage of space in each of the partition's data blocks reserved for future updates
Prompt: Percent Free Defined on INP supertype | ||
| 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 |
| Other Properties |
|---|
| LOCAL_INDEX_PARTITION 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 LOCAL_INDEX_PARTITION:
Note: