print Printer View e-mail E-mail this page Bookmark Bookmark
Oracle Migration Knowledge Base

Oracle Migration Knowledge Base


Welcome to the Oracle Migration Knowledge Base. The knowledge base contains a number of articles submitted by Oracle migration specialists worldwide.  We have hosted these articles on OTN to assist you in your migration projects. This knowledge base is updated on a regular basis from the Oracle Support Services Metalink Database which is accessible to all Oracle customers. Bookmark this page so you can easily revisit us.
Use +/- links to open/close categories. Click on any Article ID or Title to view content. Articles may be filtered on Keyword by selecting a keyword link.
Contact Us
Contact Us 		Help
Help


[-]   DataBase Schema
Article ID Article Title Keywords
239064.1 RMS: Resolve Specific Statements From Parser MANUALCHANGES   MTG   SQLSERVER   SYBASE   T_SQL   WORKBENCH  
270482.1 RMS: The Oracle Database Architecture. What is an Oracle Server? ARCHITECTURE   PTS   SCHEMA  
[-]   DataBase Target Create
Article ID Article Title Keywords
239094.1 RMS: BCP Utility Usage (Use SQL*LOADER For Oracle) LOADER   MTG   RELATIONAL  
239118.1 RMS: Mapping Dynamically-Named Temporary Tables MANUALCHANGES   MTG   SQLSERVER   SYBASE   TABLES  
300554.1 RMS: Migrate DB2 Packed Decimal Data Type DATA   DB2   PTS  
[-]   DataBase Stored Programs
Article ID Article Title Keywords
239067.1 RMS: Multiple Non-Query DML Statements Executed As A Single Statement MTG   RELATIONAL   STRINGS  
238679.1 RMS: Remove Spurious BEGIN .. END Statements MTG   PARSER   SQLSERVER   SYBASE   T_SQL  
238775.1 RMS: Singleton Select Statements (Select Into) MTG   SQL   SQLSERVER   T_SQL  
238908.1 RMS: Raise Application Error MTG   RELATIONAL  
238911.1 RMS: Manually Migrate Dynamic SQL MTG   SQL   SQLSERVER   SYBASE   T_SQL  
238913.1 RMS: Aliases should not be in Quotes ALIAS   MTG   SQLSERVER   SYBASE   T_SQL  
238914.1 RMS: SYSDATE Should Be Changed To SYSTIMESTAMP MTG   SQL   SQLSERVER   SYBASE   T_SQL   WORKBENCH  
239097.1 RMS: Naming Conflicts Between PL/SQL Variables And Column Names MTG   SQL   SQLSERVER   SYBASE   T_SQL   WORKBENCH  
238915.1 RMS: Some Column Name Changes Need To Be Manually Edited if Using Oracle Migration Workbench MTG   SQLSERVER   SYBASE   T_SQL   WORKBENCH  
238916.1 RMS: Stored Procedure Cursor While Loop Processing Logic MANUALCHANGES   MTG   SQLSERVER   STOREPROCEDURES   SYBASE   T_SQL   WORKBENCH  
238917.1 RMS: Commit Procedures With DML MTG   SQL   SQLSERVER   SYBASE  
238963.1 RMS: "||" And "+" Not Consistently Used In Converted Stored Procedures FUNCTIONS   MTG   SQLSERVER   SYBASE   WORKBENCH  
238966.1 RMS: The Procedure Should Be Able To Execute MIGRATION   MTG  
238970.1 RMS: Stored Procedures Verify Number Of Returned Reference Cursors (Results Sets) MANUALCHANGES   PTS   RESULTSETS   SQLSERVER   STOREDPROCEDURES   SYBASE   T_SQL   WORKBENCH  
270439.1 RMS: Stored Procedures with Multiple Results Sets Returned MANUALCHANGES   PTS   RESULTSETS   SQLSERVER   STOREDPROCEDURES   SYBASE   T_SQL   WORKBENCH  
238974.1 RMS: On Clauses Missing From Generated PL/SQL MTG   SQLSERVER   SYBASE   WORKBENCH  
239114.1 RMS: Migrating Variable Usage In Temporary Table Definitions MTG   RELATIONAL   TEMPTABLES  
238976.1 RMS: Ansi Compliant Outer Join Syntax ANSI_SUPPORT   MANUALCHANGES   MTG   PARSER   SQLSERVER   SYBASE   TABLES   WORKBENCH  
239073.1 RMS: Oracle Handling of Whole Numbers in Select Statements DATATYPES   PTS   SQL   SQLSERVER   SYBASE  
238984.1 RMS: Cast Statement Not Begin Converted Correctly Using Oracle Migration Workbench MTG   SQL   SQLSERVER   SYBASE   T_SQL   WORKBENCH  
239060.1 RMS: Comments on Create Index On Temp Tables Needs to be Formatted INDEX   MTG   SQLSERVER   SYBASE   TEMPTABLES   T_SQL  
239194.1 RMS: Oracle Stored Procedures Do Not Support Return Values FUNCTIONS   PTS   RESULTSETS   STOREDPROCEDURES   T_SQL   WORKBENCH  
247980.1 RMS: Replace Sybase GETDATE() Function Calls DATATYPES   MTG   SYBASE  
239068.1 RMS: Procedure Name Appended To Variables MTG   SQL   SQLSERVER   SYBASE   T_SQL   WORKBENCH  
239071.1 RMS: Exception Code Should Be Added If Needed ERROR_HANDLING   MTG   T_SQL   WORKBENCH  
239496.1 RMS: Missing Statements In A RETURN Statement MTG   PARSER   SQLSERVER   SYBASE   T_SQL   WORKBENCH  
239504.1 RMS: Sybase Empty String Issue MTG   STRINGS   SYBASE   WORKBENCH  
264978.1 RMS: Trigger Restrictions on Mutating Tables PTS   RELATIONAL   TABLE   TRIGGER  
264986.1 RMS: Migrating SQL Server and Sybase System Table and Built in Function in Queries. EMULATION   MANUALCHANGES   PTS   SQL   SQLSERVER   SYBASE  
270627.1 RMS: T-SQL Built in Function emulation inside OMWB_EMULATION schema EMULATION   PTS   SQL   SQLSERVER   SYBASE  
272689.1 RMS: DATEPART() Function is Migrated Incorrectly by OMWB T-SQL Converter FUNCTIONS   MANUALCHANGES   PTS   SQLSERVER   SYBASE   T_SQL   WORKBENCH  
272908.1 RMS: SQL Server UniqueIdentifier Data Migration DATATYPES   PTS   SQLSERVER  
272956.1 RMS: Migrating SQL Server/Sybase Global Variables PTS   SQLSERVER   SYBASE   VARIABLES  
300551.1 RMS: Migrating the SQL Server Function TOPN With Ties FUNCTION   PTS   SQL_SERVER  
[-]   Application Sybase
Article ID Article Title Keywords
239077.1 RMS: Replace Dynamically Loaded Sybase Drivers JDBC   MTG   SYBASE  
239095.1 RMS: Replace JSP Sybase Import Statements JDBC   JSP   MTG   SYBASE  
239098.1 RMS: Replace Sybase JDBC URLs JAVA   JDBC   MTG   SYBASE  
239099.1 RMS: Replace Sybase JDBC Driver Declarations JAVA   JDBC   MTG   SYBASE  
239101.1 RMS: Replace Sybase JDBC Driver Jarfiles JAVA   JDBC   MTG   SYBASE  
239102.1 RMS: Replace Empty String DATETIME Value With Oracle TO_TIMESTAMP() DATATYPES   MTG   SYBASE  
239108.1 RMS: Modify Temporary Object Names when Migrating from Sybase MTG   SYBASE   TEMPTABLES  
239193.1 RMS: Invoking Stored Procedures Using prepareStatement() in Oracle JAVA   JDBC   MTG