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

Define Table Partition in Oracle 11g

The Oracle Table Partition Editor dialog lets you create the table partitions and subpartitions. You can access the editor from the Model Explorer. Expand a table in the Model Explorer and go to Partitions.

Note: When you use the Oracle Table Partition Editor, the constraints that are applied are same as the constraints in an Oracle database. For example, one of the constraints is that you cannot create a partition on a table that is part of a cluster. This constraint applies when you create a partition on an Oracle database therefore it also applies when you use the Oracle Table Partition Editor.

Follow these steps:

1. In the Model Explorer, expand a table and go to Partitions, right-click and select New.

   A new partition is added. You can also right-click a table and click Partitions to open the Oracle Table Partition Editor.

2. Right-click a partition and click Properties to open the Oracle Table Partition Editor.
3. Complete the following fields:

   Name

   Specifies the name of the partition.

   Partition Type

   Specifies the type of partition. Select from Range, List, Hash, Interval, System, and Reference.

   Subpartition Type

   Specifies the subpartition type. The subpartition can be Range, List, Hash, or Interval.

   Note: You can create only one partition for an entity.

   General Tab

   Complete the following fields in the General tab:

   Partition Columns--Column

   Specifies the columns that are partitioned. Select one or more columns to include in the partition.

   Properties--Hash Partition Type

   Specifies the type of hash partition you want to create. This field is displayed only for the Hash partition type.

   Properties--Hash Partition Quantity

   Specifies the number of hash partitions you want to create. This field is displayed only if you select Quantity for the Hash Partition Type field.

   Properties--Interval Value

   Specifies the interval at which a new partition is automatically created. This field is displayed only for the Interval partition type.

   Properties--Key Group

   Specifies the primary key of the table included in the partition. This field is displayed only for the Reference partition type.

   Partition Elements--Name

   Specifies the name of the partition element. Use the Partition Element Editor to add or edit partition elements.

   Partition Elements--Value

   Specifies the values to the partitions.

   Regular Table Tablespaces

   Specifies the names of tablespaces to store hash partitions. Use the Tablespace Editor to add or edit tablespaces.

   Overflow Table Tablespaces

   Specifies the names of overflow tablespaces to store hash partitions. Use the Tablespace Editor to add or edit tablespaces.

4. Complete the fields on the Subpartition tab.
5. Click Close.

   The partition details are saved and the editor closes.

Note: The following properties are not supported for the partitioning feature:

• Table compression (only the COMPRESSION and NOCOMPRESSION parameters are supported)
• VARRAY parameters
• STORAGE parameters such as, ENCRYPT, FLASH_CACHE, OPTIMAL, and maxsize_clause
• LOB SECUREFILE and BASICFILE
• New COMPRESS setting with hash_partitions_by_quantity clause
• SEGMENT CREATION IMMEDIATE/DEFERRED

  Deduplication

More information:

Define a Subpartition in Oracle 11g