Any changes you make to the creation options in this page apply to all indexes. You should make these changes before you run the Migration wizard. It is not necessary to remap the Source Model after changing the creation options.
The Creation Options page of the Indexes property sheet in the Oracle Model displays the following information:
Initial Size (MB): Size of the table's first extent. Enter the size of the initial extent. Use the unit button to specify either kilobytes or megabytes. If you do not specify a size, the default is the size of 5 data blocks.
Next Size (MB): Size of the next extent to be allocated to the table. Enter the size of the next extent. Use the unit button to specify either kilobytes or megabytes. If you do not specify a size, the default is the size of 5 data blocks.
Increase Size By (%): Percent by which each extent after the second grows over the previous extent. Enter a value for percent increase. If you do not specify a value, the default is 50.
Minimum Number: Total number of extents to be allocated when a table is created in the tablespace. Enter the minimum number of extents. If you do not specify a number, the default value is 1.
Maximum Number: Maximum number of extents that can be allocated to a table created in the tablespace.
% Free: Percentage of space to leave free for updates and insertions within each of the index's data blocks. You can enter values from 0 through 99.
This page also contains the following command buttons:
Updates the creation options for all indexes with the changes you have made here. This button is disabled if no changes have been made.
Cancels the changes you have made to the creation options for all indexes and reverts back to the original value. This button is disabled if no changes have been made.
Displays online help about the creation options page of the Indexes property sheet.
You can view and edit the preferences for a particular index in the Creation Options page of the property sheet for that index.
Expand the Indexes container in the Navigator pane and select the required index to view its property sheet.