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   SYBASE  
239195.1 RMS: Replace Sybase DATEADD() Function Calls DATATYPES   FUNCTIONS   MTG   SYBASE  
247983.1 RMS: Using CONVERT() Within Sybase DATEADD() DATATYPES   MTG   SYBASE  
247984.1 RMS: Replace Sybase DATALENGTH() Function Calls
247986.1 RMS: Replace Sybase CHAR_LENGTH() Function Calls DATATYPES   MTG   SYBASE  
247987.1 RMS: Replace Sybase CHARINDEX () Function Calls FUNCTIONS   MTG   SYBASE  
247988.1 RMS: Replace Sybase SUBSTR() Function Calls MTG   SQL   SQLSERVER   SYBASE   T_SQL  
247989.1 RMS: Replace Sybase DATEDIFF() Function Calls DATATYPES   MTG   SYBASE  
247990.1 RMS: Replace Sybase DATEPART() Function Calls DATATYPES   MTG   SYBASE  
247991.1 RMS: Replace Sybase DATENAME() Function Calls DATATYPES   MTG   SYBASE  
248058.1 RMS: Replace Sybase ISNULL() Function Calls FUNCTIONS   MTG   SYBASE  
[-]   Application SQLServer
Article ID Article Title Keywords
248062.1 RMS: Replace Left Outer Join Statements MTG   SQL   SQLSERVER   SYBASE   T_SQL  
[-]   Application JDBC
Article ID Article Title Keywords
239191.1 RMS: Invoking Functions Using JDBC CallableStatement Object FUNCTIONS   JAVA   JDBC   MTG  
[-]   Application Java
Article ID Article Title Keywords
239075.1 RMS: Hard Coded Paths MANUALCHANGES   MTG   RELATIONAL  
[-]   Application Forms
Article ID Article Title Keywords
299425.1 RMS: Create a Report Object inside Forms FORMS   PTS   REPORTS  
299428.1 RMS: Reset Case of Image Name for Iconic Buttons FORMS   ICONS   PTS  
299464.1 RMS: Set a Format Mask for Numeric Items FORMAT   FORMS   NLS   PTS  
299465.1 RMS: Workaround for RUN_PRODUCT(FORMS,...) CALL_FORM   FORMS   OPEN_FORM   PTS   RUN_PRODUCT  
299466.1 RMS: Setting Quotes around Parameter Values ADD_PARAMETER   FORMS   PTS   REPORT   SPACE  
299467.1 RMS: Set a Format Mask for Numeric Items CASE   FORMS   ICON   ICONIC   JDAPI   PTS  
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy