A
List of Questions

This appendix lists the questions contained in the chapters of this FAQ.

General Migration Workbench Questions

What release of the Oracle Server does the Migration Workbench support?

What platforms does Oracle Migration Workbench run on?

Does the Migration Workbench support UNIX?

Can I download the Migration Workbench from the Web?

Why am I not able to access Oracle Technology Network (OTN)?

What should I do if I cannot download the Migration Workbench from Oracle Technology Network (OTN)?

Why do I receive a blank DOS window or one of the following error messages while launching the Migration Workbench from Windows 98?

Where can I find out more about Oracle Migration Workbench error messages?

What is the difference between Oracle Transparent Gateway (OTG) and the Migration Workbench?

Does the Migration Workbench provide NLS support?

Does the Migration Workbench support object names with spaces in their names?

Does the Migration Workbench use strong REF CURSORS?

Can I install the Migration Workbench into an Oracle home directory that contains a release of the Oracle Server earlier than Oracle9i?

How do I re-create an Oracle Migration Workbench Repository?

How do I create a tnsnames.ora file?

What should I do if I cannot launch the Oracle Migration Workbench? I attempt to do so but nothing happens.

I attempt to launch the Oracle Migration Workbench and the splash screen appears then quickly disappears. Why does this happen?

Can I migrate single table data?

Can I change the data type of a single column?

Are constraints disabled when loading the data?

How are duplicate object names handled?

What are the object naming guidelines for the Migration Workbench?

How does the Migration Workbench handle reserved words?

How does the Migration Workbench migrate datatypes that the Oracle Server does not support?

What do the following error messages mean?

How are NCHAR, NVARCHAR, NTEXT, or MEMO data types mapped within the Oracle Server?

Does the Migration Workbench use SQL*Loader to control files for loading data?

Can I modify the SQL*Loader control files for loading the data?

Does the data migration process slow down dramatically when migrating tables that contain large volumes of binary data, such as images, binary data, or OLE objects?

What should I do if I receive the error "ORA-22866: default character set is of varying width" when migrating to a destination Oracle database created with the UTF8 character set?

What is the meaning of the error message "ORA-01426: numeric overflow" in the Log window?

What does the error "Hostdef does not exist" mean?

Why do I receive the "ORA-02298: parent key not found" error message?

How do client applications access the data that has been migrated from my source database to an Oracle database?

Does the Oracle Server have implicit date conversion from a character string?

Can I migrate a single schema object?

Can I rename a schema object?

How do I manage case-sensitivity queries?

Can the Migration Workbench migrate multiple databases?

Does the Migration Workbench allow multi-character field delimiters?

How do I modify the storage options for a table?

Do I need to edit table defaults?

How does the Oracle Server handle temporary tables?

How do I get help on Migration Workbench issues?

How do I know what error messages occurred when running the Migration Wizard?

All error messages are logged to the Log window and the columns of the Log window can be sorted by clicking on the column header. During the creation phase of the migration, the Migration Wizard creates three log files that record all successful CREATE statements and ALTER statements, the equivalent DROP statements and ALTER statements, and all SQL statements that the Migration Workbench was unable to execute. The location of these log files is governed by the log file directory setting in the Logging page of the Options dialog box. The default location is %ORACLE_HOME%\omwb\log. If the Migration Workbench fails to respond, check the contents of the %ORACLE_HOME%\Omwb\log\Error.log file to see if there are any error messages recorded. The contents of this file can be sent to the Migration Workbench development team at infomwb_ww@oracle.com. You can also generate reports from the Migration Workbench. This provides you with a formatted list of the error messages.

Informix Dynamic Server Questions

Are there any schema migration limitations for Informix Dynamic Server?

What do I use to connect to an Informix Dynamic Server?

Why do I have problems migrating the Defaults schema when I use the default repository?

What must I do when the stored procedure parameters that are declared using the LIKE syntax are incorrectly parsed to type CLOB?

Why does the stored procedure parser fail in the Migration Workbench?

Does the Informix Dynamic Server Stored Procedures Parser have any limitations?

Does the Migration Workbench fully support the migration of LOB data using SQL*Loader scripts?

Microsoft Access Questions

Does the Migration Workbench support Microsoft Access 2000 migration to Oracle?

How do I migrate a Microsoft Access database to an Oracle database?

What software do I need to migrate a Microsoft Access 97 database to an Oracle database?

What software do I need to migrate a Microsoft Access 2000 database to an Oracle database?

What happens if the following message appears when you log into the Oracle Migration Workbench: "There is no Microsoft Access ODBC driver software installed on this system. Please install the software before using the Microsoft Access plugin."

Why does the Oracle Model hang when I map foreign keys?

What should I do if I receive the "ORA-00001: Unique constraint violated message displayed in error.log or as an alert" error message?

What if I receive one of the following messages while attempting to launch the Oracle Migration Workbench Exporter for Microsoft Access:

Why does the Migration Workbench not handle validation rules with the following syntax:

Can I migrate my Microsoft Access security settings to an Oracle Server?

How do I avoid erroneous relations within Microsoft Access 95?

Can I migrate a replica Microsoft Access database?

Can I use the Migration Workbench to migrate multiple Microsoft Access databases to a single Oracle user?

Can my hyperlinks work after I migrate my database to an Oracle Server?

What does the message "No primary key defined on table name; you are unable to update records after migration." mean?

What should I do if I encounter the error message "JET/DAO Error 3050: Couldn't lock file"?

Why must I define an Oracle ODBC data source when migrating from Microsoft Access?

Why must I modify the Microsoft Access database?

Does the Migration Workbench support offline data loading in Microsoft Access?

How do I migrate the Microsoft Access Memo columns in tables?

What should I do if the following error is reported during data load from Microsoft Access to Oracle: "EXCEPTION: LoadTableData.run() : [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides"?

Microsoft SQL Server & Sybase Adaptive Server Questions

Does the Migration Workbench support Microsoft SQL Server 6.0? If not, are there any plans to support this version of Microsoft SQL Server?

Can I migrate from Microsoft SQL Server or Sybase Adaptive Server to an Oracle7 database using the Migration Workbench?

What is the meaning of the "Owner name is NULL. Check the MASTER database is correctly recovered" message?

Why must I define a SQL Server or Sybase System 11 ODBC data source?

Why does a SELECT statement on a temporary table fail when I have migrated a stored procedure to a destination Oracle database?

Can you migrate roles and privileges using the Migration Workbench?

How does the Migration Workbench map the Microsoft SQL Server database?

How are Microsoft SQL Server and Sybase Adaptive Server user-defined types handled?

What happens if I receive the following error message: "Failed to load Source Model [INTERSOLV] [IDBC SQL Server] [SQL Server] WARNING! Some characters could not be converted into client's character set. Unconverted bytes were changed to question marks (?)" ?

Does the Migration Workbench support offline data loading in Microsoft SQL Server or Sybase Adaptive Server data migration?

How do I run BCP from a client system?

Are there any guidelines for how long it takes to convert high volumes of data from Microsoft SQL Server or Sybase Adaptive Server to an Oracle Server using the Migration Workbench?

How are TIMESTAMP data-types migrated?

What is the Microsoft SQL Server or Sybase Adaptive Server DATETIME data type mapped to within an Oracle database?

How does the Migration Workbench handle Microsoft SQL Server 7.0 VARCHAR data types greater than 4000?

What is the equivalent of the Microsoft SQL Server or Sybase Adaptive Server SYSOBJECTS table in an Oracle database?

Can I edit a stored procedure, trigger, view, or check constraint in the Source Model?

How are Microsoft SQL Server and Sybase Adaptive Server EXEC statements parsed?

Can I use double brackets (()) in T/SQL statements?

Does the Migration Workbench parser support cast operations?

Can I use the LIKE clause in SQL statements?

Can I migrate subqueries in the SELECT clause of Microsoft SQL Server and Sybase Adaptive Server?

Does an Oracle Server support full UNIX-style regular expression handling?

Are DUMP TRANSACTION and DROP INDEX SQL commands supported?

How do I avoid problems with cyclic procedures?

Does the Migration Workbench support the conversion of T/SQL stored procedures that return multiple result sets?

How are result sets and dynasets returned to the calling program?

Can I use the Migration Workbench to migrate only stored procedures?

How are DDL commands handled?

Can you use DLL commands in an Oracle stored procedure?

Does the Migration Workbench support bitwise operations?

Can I parse a specific stored procedure?

How are cross-database procedure calls converted?

How does the Migration Workbench migrate Microsoft SQL Server outer joins to Oracle outer joins?

How can I convert full outer joins from a Microsoft SQL Server database to an Oracle database?

How do Microsoft SQL Server outer joins compare to ODBC?

How does the Migration Workbench handle complex case statements?

Does the Migration Workbench support global variables?

How does the Migration Workbench implement the migration of global variables?

How are IDENTITY columns mapped to an Oracle database?

How does the Migration Workbench handle the @@SERVERNAME global variable?

How does the Migration Workbench handle the @@SPID global variable?

How does the Migration Workbench handle the @@TRANCOUNT global variable?

How does the Migration Workbench handle the @@TRANSTATE global variable?

Are there any issues with the use of deleted and inserted pseudo columns from Microsoft SQL Server?

How are rules handled?

How are rules with the getDate() function converted?

MySQL Questions

Are there any guidelines for how long it takes to convert high volumes of data from MySQL to an Oracle Server using the Migration Workbench?

Why do I receive the "Communication link failure: bad handshake" error message when migrating from MySQL?