Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | INDEX_PARTITION |
| Short Name | INP |
| View Name | CI_INDEX_PARTITIONS |
| Description | A partition into which an index has been divided. It can have |
| different physical attributes to the index (eg tablespace, storage | |
| definition). | |
| Partitions for local indexes have different characteristics to | |
| partitions for global indexes, and so INDEX_PARTITION is sub-typed | |
| into LOCAL_INDEX_PARTITION and GLOBAL_INDEX_PARTITION. | |
| New capability in Oracle8 | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Non-instantiable super-type of | GLOBAL_INDEX_PARTITION |
| LOCAL_INDEX_PARTITION | |
| As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc | |
| Underlying table: | SDD_INP |
| Changes: | Summary of changes to INDEX_PARTITION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| INDEX_STORAGE_REFERENCE | N |
Prompt: Index
Transferable only if null |
Must be a partition of one and only one INDEX_STORAGE | |
| STORAGE_DEFINITION_REFERENCE | Y | Prompt: Storage Definition | May be limited by one and only one STORAGE_DEFINITION | |
| TABLESPACE_REFERENCE | Y | Prompt: Tablespace | 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 | 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 | ||
| MAXIMUM_TRANSACTION | NUMBER(3, 0) | Y | Maximum number of concurrent transactions that can update a data block allocated to the partition
Prompt: Max Trans | ||
| 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 | ||
| PERCENT_FREE | NUMBER(3, 0) | Y | Percentage of space in each of the partition's data blocks reserved for future updates
Prompt: Percent Free | ||
| 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 |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference INDEX_PARTITION:
Note: