Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Define a Partition Element in Oracle 11g

Define a Partition Element in Oracle 11g

Use the Oracle Partition Element Editor to define the boundary, subpartition element, and storage properties for a partition. The partition properties you can assign are identical to those you can assign in the General tab in the Oracle Table Editor, Oracle Materialized Views Editor, and Oracle Materialized View Log Editor. The partition properties however, apply only to the specific partition, and not the entire table, materialized view, or materialized view log.

To open the Oracle Partition Element Editor, click Partition Element in the Oracle Table Partition Editor dialog.

Follow these steps:

1. Select the partition for which you want to define partition elements.
2. Click New and a new partition element is added with a default name.
3. Complete the fields on the Boundaries tab.
4. Complete the fields on the Subpartition Elements tab.
5. Complete the fields on the Regular Storage tab.
6. Complete the fields on the Overflow Storage tab.
7. Click the Where Used tab to review where the selected table partition element is used.
8. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
9. (Optional) Click the UDP tab to work with user-defined properties for the object.
10. (Optional) Click the Notes tab to view and edit user notes.
11. Click Close.

    The Oracle Partition Element Editor closes.

Define Partition Boundaries in Oracle 11g

The Oracle Partition Element Editor dialog opens when you click Partition Element Editor in the Partition Elements section of the Oracle Table Partition Editor dialog.

The partition properties you can assign are identical to those you can assign in the General tab in the Oracle Table Editor, Oracle Materialized Views Editor, and Oracle Materialized View Log Editor. The partition properties however, apply only to the specific partition, and not the entire table, materialized view, or materialized view log.

The Boundaries tab lets you define the ending value for a partition element.

Follow these steps:

1. Complete the following fields in the Boundaries tab:

   Name

   Specifies the name of the boundary.

   Partition Column

   Specifies the column that is participating in the partition. This field is populated automatically.

   Ending Value

   Specifies the upper limit for the partition boundary.

2. Click Close.

   The Oracle Partition Element Editor closes.

Define Valid Values for Partition Elements in Oracle 11g

The Oracle Partition Element Editor dialog opens when you click Partition Element Editor in the Partition Elements section of the Oracle Table Partition Editor dialog.

The partition properties you can assign are identical to those you can assign in the General tab in the Oracle Table Editor, Oracle Materialized Views Editor, and Oracle Materialized View Log Editor. The partition properties however, apply only to the specific partition, and not the entire table, materialized view, or materialized view log.

The Valid Values tab lets you define the values for a list type of partition element. The tab is displayed only if you are creating a List type of partition or subpartition.

Follow these steps:

1. Complete the following fields in the Valid Values tab:

   Name

   Specifies the name of the value. This field is read-only

   Display

   Specifies the partition value of the list type of partition.

   Definition

   Specifies the definition for the corresponding value. Click the editor icon to cut, copy, paste, or print the definition.

2. Click Close.

   The Oracle Partition Element Editor closes.

Define a Subpartition Element in Oracle 11g

The Oracle Partition Element Editor dialog opens when you click Partition Element Editor in the Partition Elements section of the Oracle Table Partition Editor dialog.

The partition properties you can assign are identical to those you can assign in the General tab in the Oracle Table Editor, Oracle Materialized Views Editor, and Oracle Materialized View Log Editor. The partition properties however, apply only to the specific partition, and not the entire table, materialized view, or materialized view log.

The Subpartition Element tab lets you define subpartition elements for a partition element.

Follow these steps:

1. Click New in the Subpartition Elements tab and a new subpartition element is added.
2. Click Partition Element Editor to add subpartition elements to the selected partition element.
3. Complete the following fields:

   Name

   Specifies the name of the subpartition element.

   Partition Value

   Specifies the value of the subpartition. This field is populated automatically.

4. Click Close.

   The Oracle Partition Element Editor closes.