The Oracle Partition Description Dialog opens when you click on the Edit Properties column in the Partitions section of the Range option of the Oracle Table Editor, Oracle Materialized Views Editor, or Oracle Materialized View Log Editor Partitions tab.
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 following describes the options for the Oracle Partition Description Dialog:
A drop-down list box where you can select a tablespace from the current model to which you assign storage properties. If you need to edit the properties of a tablespace you select, click the 
button to open the Oracle Tablespace Editor.
Enter values for the following options for Extents:
Specify in bytes the size of the object's first extent.
Specify in bytes the size of the next extent to allocate to the object.
Specify the percent by which the third and subsequent extents grow over the preceding extent.
Specify the total number of extents to allocate when the object is created.
Specify the total number of extents, including the first, that Oracle can allocate for the object. When you select this option, select one of the following options for Maxextents:
If you select this option, enter a value in the text box.
Enter values for the following options for Space Usage:
Specify the limit Oracle should use to determine when additional rows can be added. The value of this parameter is expressed as a whole number and interpreted as a percentage.
Specify the space to be reserved for each data block for future expansion. The value of this parameter is expressed as a whole number and interpreted as a percentage.
Select this check box if you want to specify a default buffer pool. When you select this option, select one of the following options for Buffer Pool:
Puts blocks from the segment into the KEEP buffer pool.
Puts blocks from the segment into the RECYCLE buffer pool.
Specify DEFAULT to indicate the default buffer pool.
Enter a value for the following option for Number Transactions:
Specify the initial number of concurrent update transactions allocated for data blocks.
Enter values for the following options for Freelists:
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.
When you select this option, select one of the following options for Redo Log:
When you select this option, select one of the following options for Compression:
This option is only available if the table is an index organized table. When you select this option and click the Overflow Storage button, it opens the Oracle Storage Properties Dialog.
When you click the LOB Storage button it opens the Oracle LOB Storage dialog.
|
Copyright © 2017 erwin Inc.
All rights reserved.
|
|