Physical Modeling › Oracle Physical Property Editors › Oracle Table Editor › Oracle Hash Subpartition Dialog

Oracle Hash Subpartition Dialog

Use the Oracle Subpartition dialog to modify the properties for a subpartition. This dialog opens when you click on the Template button in the Partitions tab of the Oracle Table Editor, Oracle Materialized Views, and the Oracle Materialized View Log Editor. This is only available if your partitioning option is Composite-Hash. The following describes the options for the Oracle Hash Subpartition Dialog:

Subpartition type

Select this check box and select one of the following subpartition types:

Subpartition by quantity

Enter a value in the Number of Subpartitions list box and select a tablespace in the Tablespace list box. Click on the button to open the Oracle Select Tablespaces Dialog.

Subpartition by name

Enter a value in the Subpartition Name column. Click the button in the Edit Properties column to open the Oracle Partition Storage Dialog.