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

Define Overflow Storage Properties for Oracle Partition Elements

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 Overflow Storage tab lets you define the overflow storage properties for a partition element.

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. Click New to add a partition element. Provide a name for the new partition element.
2. Complete the following fields in the Overflow Storage tab:

   Overflow Storage

   Specifies the type of storage for the selected partition element.

   Tablespace

   Specifies the tablespace that stores the partition data. Select the check box to make the remaining fields editable.

   Extents

   Enter values for the following options for Extents:

   Initial

   Specifies the size of the first extent of the object in bytes.

   Next

   Specifies in bytes the size of the next extent to allocate to the object.

   Percent Increase

   Specifies the percent by which the third and subsequent extents grow over the preceding extent.

   Min Extents

   Specifies the total number of extents to allocate when the object is created.

   Max Extent Type

   Specifies the type of extents that are allocated to the object. Select Unlimited or Specific Value.

   Max Extents

   Specifies the total number of extents, including the first, that Oracle can allocate for the object.

   Space Usage

   Enter values for the following options for Space Usage:

   Percent Used

   Specifies the space that is reserved for each data block for future expansion. The value of this parameter is expressed as a whole number and interpreted as a percentage.

   Percent Free

   Specifies the limit Oracle must use to determine when more rows can be added. The value of this parameter is expressed as a whole number and interpreted as a percentage.

   Buffer Pool

   Buffer Pool

   Specifies the type of buffer pool you want to use. Select Keep, Recycle, or Default.

   Transactions

   Initial Concurrent Transactions

   Specifies the initial number of concurrent update transactions that are allocated for data blocks.

   Max Concurrent Transactions

   Specifies the maximum number of concurrent update transactions that are allocated for data blocks.

   Free List

   Free Lists

   Specifies the number of free lists for each of the free list groups for the table, partition, cluster, or index.

   Free List Groups

   Specifies the number of groups of free lists for the database object you are creating.

   Redo Log

   Suppress Logging

   Specifies whether you want to create redo log files.