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 Regular Storage tab lets you define the 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:
Specifies the type of storage for the selected partition element.
Specifies the tablespace that stores the partition data. Select the check box to make the remaining fields editable.
Enter values for the following options for Extents:
Specifies the size of the first extent of the object in bytes.
Specifies in bytes the size of the next extent to allocate to the object.
Specifies the percent by which the third and subsequent extents grow over the preceding extent.
Specifies the total number of extents to allocate when the object is created.
Specifies the type of extents that are allocated to the object. Select Unlimited or Specific Value.
Specifies the total number of extents, including the first, that Oracle can allocate for the object.
Specifies the way that you want to compress the tablespace. Select Default, None, or Compress.
Enter values for the following options for Space Usage:
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.
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.
Specifies the type of buffer pool you want to use. Select Keep, Recycle, or Default.
Specifies the initial number of concurrent update transactions that are allocated for data blocks.
Specifies the maximum number of concurrent update transactions that are allocated for data blocks.
Specifies the number of free lists for each of the free list groups for the table, partition, cluster, or index.
Specifies the number of groups of free lists for the database object you are creating.
Specifies whether you want to create redo log files.
|
Copyright © 2017 erwin Inc.
All rights reserved.
|
|