Options Dialog Box: General Page

The General page of the Options dialog box allows you to determine general options for your project. These options include the performance options outlined below as well as the ability to specify the following:

Data File Directory

Determines the directory where any Oracle8i or Oracle8i Lite data files associated with the tablespaces defined in the Oracle Model are created. These are created after you run the Migration wizard and choose to create the users and their tables.

Create ANSI-Compliant Names

Determines whether all schema object names mapped from the source database have ANSI-compliant names when created in the Oracle8i or Oracle8i Lite database.

Create Foreign Keys with 'ON DELETE CASCADE' Option

Determines whether foreign keys created in the Oracle8i or Oracle8i Lite database have the 'ON DELETE CASCADE' option.

Performance

Insert Batch Size: Specifies the number of rows batched in the Migration Workbench before they are sent to the Oracle8i or Oracle8i Lite database. Overwrite the existing value to change it.

Commit Count: Specifies the number of rows after which the Migration Workbench issues a commit. The existing value is overwritten.

Row Prefetch Size: Specifies the number of rows fetched by the Migration Workbench when reading from an Oracle8i or Oracle8i Lite database. The existing value is overwritten.

This page also contains the following command buttons:

OK

Records the options you have specified and exits the Options dialog box.

Cancel

Exits the Options dialog box.

Help

Displays online help about the Options dialog box.