| Oracle Migration Workbench FAQ Release 1.3.0.0.0 for Windows NT and Windows 95/98 Part Number Z26938-01 |
|
This 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?
How do I get help with issues regarding the Migration Workbench?
Where can I download the Migration Workbench documentation?
Does the Migration Workbench support Unix?
Does the Migration Workbench support MS 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 Oracle 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 Oracle's 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 and 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 error "ORA-01426: numeric overflow" in the Log window?
Does the Migration Workbench support 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 Worbench support?
What platforms does Oracle Migration Workbench run on?
How do I know what errors occurred when running the Migration wizard?
Where do I e-mail my questions?
Is the Migration Workbench Year 2000-compliant?
How do I deal with case-sensitivity queries?
Does Oracle have implicit date conversion from a character string?
How do I avoid problems with cyclic procedures?
What software do I need to migrate MS Access to Oracle?
Can I migrate my MS Access security settings to Oracle?
Can I migrate a replica MS Access database?
Can I use the Migration Workbench to migrate multiple MS Access databases to a single Oracle user?
Can my hyperlinks work once I migrate my database to Oracle?
What should I do if I encounter the error "JET/DAO Error 3050: Couldn't lock file"?
Why must I define an MS Access ODBC data source?
Why must I define an Oracle ODBC data source when migrating from MS Access?
Why do I need to modify the MS Access database?
Does the Migration Workbench support offline data loading in MS Access?
How do I migrate the MS Access Memo columns in tables?
Can I migrate from MS SQL Server or Sybase 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 MS SQL Server and Sybase?
Why does the Migration Workbench hang when I try to load the source master database from Sybase?
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 MS SQL Server or Sybase DATETIME data type mapped to within Oracle?
How does the Migration Workbench handle MS SQL Server 7.0 VARCHAR data types greater than 4000?
Does the Migration Workbench support offline data loading in MS SQL Server or Sybase data migration?
How do I run BCP from a client computer?
What is the equivalent of the MS SQL Server or Sybase SYSOBJECTS table in Oracle?
How are MS SQL Server and Sybase 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 stored procedures only?
Can you use DLL statements 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 MS 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 MS 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 MS 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 MS SQL Server database?
How are MS SQL Server and Sybase 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 MS SQL Server and Sybase?
|
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|