Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | TABLE_PARTITION |
| Short Name | TBP |
| View Name | CI_TABLE_PARTITIONS |
| Description | A partition into which a table has been divided, based on a |
| partition key of one or more columns. | |
| Table partitions have the same logical attributes as the table | |
| (columns, datatypes etc), but can have different physical attributes | |
| (tablespace, storage definition) | |
| New capability in Oracle8 | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_IMPLEMENTATION_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_TBP |
| Changes: | Summary of changes to TABLE_PARTITION in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| TABLE_IMPLEMENTATION_REFERENCE | N |
Prompt: Table Implementation
Transferable only if null |
Must be a partition of one and only one TABLE_IMPLEMENTATION | |
| 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 |
| 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 table 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 | ||
| PERCENT_USED | NUMBER(3, 0) | Y | Minimum percentage of used space that Oracle maintains for each data block
Prompt: Percent Used | ||
| SEQUENCE_NUMBER | NUMBER(6, 0) | N | Sequence in which this table partition is to appear amongst other table partitions in the generated DDL
Prompt: Usage Sequence System maintained: API provides a value only if left null by the user | ||
| VALUE_LESS_THAN | VARCHAR2(240) | N | The 'VALUE LESS THAN' parameter for this table partition. In the case of a composite partition key, the multiple parameters are separated by commas eg "6,5,0". Surrounding brackets added by Server Generator in generated DDL
Prompt: Value Less Than Uppercase | ||
| 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 |
|---|
| TABLE_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 TABLE_PARTITION:
Note: