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:
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.
Determines whether all schema object names mapped from the source database have ANSI-compliant names when created in the Oracle8i or Oracle8i Lite database.
Determines whether foreign keys created in the Oracle8i or Oracle8i Lite database have the 'ON DELETE CASCADE' option.
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:
Records the options you have specified and exits the Options dialog box.
Exits the Options dialog box.
Displays online help about the Options dialog box.