Oracle Migration Workbench Frequently Asked Questions (FAQ)
Release 1.4.1 for Microsoft Windows 95/98/2000, Microsoft Windows NT, and Linux Red Hat 6.2

Part Number A90242-01

Contents

Index

Go to previous page Go to next page

1
Listing of Questions

This Frequently Asked Questions (FAQ) provides information about the Oracle Migration Workbench. They are cataorized by the plugins that the Migration Workbench supports. The categories are:

General Migration Workbench

Can I download the Migration Workbench from the Web?

Where can I download the Migration Workbench documentation?

Does the Migration Workbench support Unix?

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

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

How do I create a new Oracle Migration Workbench Repository?

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

What do the following error messages mean? ORA-00903 - Invalid table name ORA-00904 - Invalid column name ORA-00942 - Table or view does not exist

How do I create a tnsnames.ora file?

Can I migrate a single schema object?

Can I rename a schema object?

Can I maintain case-sensitivity of schema object names when migrating?

Can the Migration Workbench migrate multiple databases?

How does the Migration Workbench handle reserved words?

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

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

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

What is the difference between the Migration Workbench and the Oracle Migration Companion CD-ROM?

What is the meaning of error "ORA-01400: cannot insert null"?

How do I configure a Data Source Name (DSN) using ODBC?

How does the Migration Workbench handle non-Oracle data types?

Can I change the data type of a single column?

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

Can I migrate single table data?

Are constraints disabled when loading the data?

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?

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?

Does the Migration Workbench allow multi-character field delimiters?

Does the Migration Workbench provide NLS support?

How are temporary tables handled in Oracle8?

How do I customize the storage options for a table?

Do I need to edit table defaults?

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

What release of Oracle8 does the Migration Workbench support?

What platforms does Oracle Migration Workbench run on?

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

Where do I e-mail my questions?

Is the Migration Workbench Year 2000-compliant?

How do I manage case-sensitivity queries?

Does Oracle have implicit date conversion from a character string?

How do I avoid problems with cyclic procedures?

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?

Why is it that I cannot 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 error messages below while launching the Migration Workbench from Windows 95/98?

Are there object naming guidelines for the Migration Workbench?

Informix Dynamic Server

What happens if error messages are not correctly reported?

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

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

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

Are there any schema migration limitations for Informix Dynamic Server?

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

How do I migrate a Microsoft Access database to Oracle?

What software do I need to migrate Microsoft Access to Oracle?

Can I migrate my Microsoft Access security settings to Oracle?

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 once I migrate my database to Oracle?

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 a Microsoft Access ODBC data source?

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

What happens if I receive the message "Data not found" when I enter the Microsoft Access ODBC data source in the Capture Wizard?

Why do I need to 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?

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?

Microsoft SQL Server & Sybase Adaptive Server

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

How are duplicate object names handled?

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

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

Does the Migration Workbench support migrating milliseconds in Microsoft SQL Server and Sybase Adapative Server?

What does the error message "Owner name is NULL. Check the MASTER database is correctly recovered" mean?

Why does the Migration Workbench hang when I try to load the source master database from Sybase Adaptive Server?

Why do I need to define a SQL Server or Sybase System 11 ODBC data source?

How are TIMESTAMP data-types migrated?

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

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

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 Oracle using the Migration Workbench?

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

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

Can I use the LIKE clause in SQL statements?

Does Oracle support full UNIX-style regular expression handling?

Are DUMP TRANSACTION and DROP INDEX SQL commands supported?

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

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

Does the Migration Workbench use weak REF CURSORS?

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 are Microsoft SQL Server outer joins migrated to Oracle outer joins by the Migration Workbench?

How can I convert full outer joins from SQL Server to Oracle?

How does 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 Oracle?

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

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

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

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

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

Why do I see an asterisk (*) in the packages produced by the parser?

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 data types handled?

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

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

What should I do if the Migration Workbench hangs while capturing the source database?

MySQL

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

Why do I receive the "Communication link failure: bad handshake" error message?


Go to previous page Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.

Contents

Index