Any changes you make to the creation options in this page apply to all tables. 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 Tables 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 in each of the table's, object table's OIDINDEX, or partition's data blocks reserved for future updates to the table's rows. You can enter a value from 0 through 99.
% Used: Minimum percentage of used space that Oracle maintains for each data block of the table, object table OIDINDEX, or index-organized table overflow data segment. A block becomes a candidate for row insertions when its used space falls below the % Used value. You can enter a value from 1 through 99; the default value is 40.
This page also contains the following command buttons:
Updates the creation options for all tables 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 tables 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 Tables property sheet.
You can view and edit the preferences for a particular table in the Creation Options page of the property sheet for that table.
Expand the Tables container in the Navigator pane and select the required table to view its property sheet.