| 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 |
|
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:
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?
How do I create a new Oracle Migration Workbench Repository?
How do I re-create an Oracle Migration Workbench Repository?
How do I create a tnsnames.ora file?
Can I migrate a single 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 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?
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)?
Are there object naming guidelines for the Migration Workbench?
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?
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 my hyperlinks work once I migrate my database to Oracle?
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?
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?
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?
Why do I need to define a SQL Server or Sybase System 11 ODBC data source?
How are TIMESTAMP data-types migrated?
How do I run BCP from a client system?
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?
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?
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?
Why do I receive the "Communication link failure: bad handshake" error message?
|
|
![]() Copyright © 2001 Oracle Corporation. All Rights Reserved. |
|