The creation of the Oracle Model involves analyzing the data stored in the Source Model and converting it into its Oracle equivalent in the Oracle Model. This includes converting data types from the source database into equivalent Oracle data types. You can view the default data type mappings in the Capture Wizard or in the Options dialog box and change them if you wish.
The Migration Workbench converts the source database to a non-ANSI compliant Oracle database by default. In this case, an underscore is appended to any object whose name matches that of an Oracle reserved word. However, you can change this default setting prior to the creation of the Oracle Model to ensure that the Oracle Model will be ANSI compliant. To do this, you should select the Create ANSI-compliant names option in the General page of the Options dialog box. If you change this setting, double quotes are placed around the object name.
When the Oracle Model is created, dependency information for an object is gathered and stored. For example, information about the table on which a check constraint depends is stored in the Oracle Model. This means that if a table is not generated, the check constraint cannot be generated.
Once the Oracle Model has been created, you can view it by clicking the Oracle Model tab in the Navigator Pane. The property sheets for the schema objects display how the source database will be represented in the destination Oracle database. At this stage, you can change the creation options for users and the storage options for indexes and tables.