Oracle Upsizing Wizard: Step 8 – Specify Cluster Tables

See Also

In this step, you select the tables to be included in each cluster. You specify the tables to be included in different clusters by selecting a different cluster name, and then selecting tables for that cluster.

Each cluster should include at least one table. If a listed cluster does not have at least one table assigned to it, you should move back to Step 7 and remove the cluster.

The cluster columns must correspond in both datatype and size for columns in each of the clustered tables; they need not correspond in value. You cannot specify integrity constraints as part of the definition of a cluster key column.

Dialog Box Options

Clusters

Displays the cluster name. To select a different cluster, expand the list and select a cluster name.

Available tables

Displays a list of tables from which you can choose to be included in the cluster. Tables already participating in another cluster are not displayed.

Selected tables

Displays the tables you've selected to be included in the cluster.

Verify

Tests the selected tables to ensure that their common columns correspond in both datatype and size. If the selected tables don't pass the verification test, the Upsizing Wizard remains on this step.