Table: Creation Options Page

You should make any changes to the creation options for a particular table 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 property sheet for a particular table in the Oracle Model displays the following information:

Tablespace

Drop-down list displaying the tablespaces available in the Oracle Model from which you can choose the tablespace in which this table is to be created. Tablespaces can be added to and removed from the Oracle Model. For more information, see the Tablespaces Property Sheet.

Extents

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.

Space Usage

% 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:

Apply

Updates the creation options for this table with the changes you have made here. This button is disabled if no changes have been made.

Revert

Cancels the changes you have made to the creation options for this table and reverts back to the original value. This button is disabled if no changes have been made.

Help

Displays online help about the creation options page of the property sheet for this table.