My Oracle Support Banner

Migrating From IBM DB2 UDB to Oracle (Doc ID 1148493.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle SQL Developer - Version 3.0 to 4.1.1 [Release 3 to 4]
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This document provides supplementary reference information for migrating IBM DB2 UDB databases to Oracle using the Oracle SQL Developer tool. It includes information to help you plan for the migration and to solve any problems that might occur during or after the migration. This document DOES NOT apply to the DB2 Databases for Mainframes, i.e. DB2/i (for iSeries machines running i/OS) or DB2/z (machines running z/OS). 

Scope

This documents supplements some DB2 migration information that is included in the SQL Developer online help and in Oracle SQL Developer User's Guide.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Introduction
 Oracle and DB2 Compared
 2.1 Data Storage Concepts
 2.1.1 Oracle Data Storage Concepts
 2.2 Database Schema Migration
 2.2.1 Schema Object Similarities
 2.2.2 Database Schema Object Names
 2.2.3 Design Considerations
 2.2.3.1 Database Mappings
 2.2.3.2 Referential Integrity Constraints
 2.2.3.3 Table space Mappings
 2.2.3.4 Alias Mappings
 2.2.3.5 Identity Column Mappings
 2.3 Data Types
 2.3.1 Data Types in Oracle and IBM DB2
 2.3.2 Character Data Types
 2.3.2.1 Fixed-Length Character Strings
 2.3.2.2 Varying-Length Character Strings
 2.3.2.3 Large Object Data Types
 2.3.2.3.1 Character Large Objects (CLOBs)
 2.3.2.3.2 Double-Byte Character Large Objects (DBCLOBs)
 2.3.2.3.3 Binary Large Objects (BLOBs)
 2.3.3 Graphic Data Types
 2.3.3.1 DBCS Data
 2.3.3.2 UCS-2 Data
 2.3.4 Numeric Data Types
 2.3.5 Date Data Types
 2.3.6 String Representation of Datetime Values
 2-12 Oracle SQL Developer Supplementary Information for IBM DB2 Migrations
 2.3.7 IBM DB2 Datalinks
 2.3.8 User-Defined Distinct Data Types
 2.3.9 IBM DB2 Structured Data Types
 Database Security
 3.1 Mapping IBM DB2 UDB Groups and Users
 3.2 Mapping IBM DB2 UDB Authorization Levels to Oracle
 3.2.1 Instance Level Authorities
 3.2.2 Database Level Authorities
 3.3 Mapping IBM DB2 UDB Privileges to Oracle
 3.3.1 Table and Column Privileges
 3.3.1.1 CONTROL Privilege
 3.3.1.2 ALTER Privilege
 3.3.1.3 DELETE Privilege
 3.3.1.4 INDEX Privilege
 3.3.1.5 INSERT Privilege
 3.3.1.6 REFERENCE Privilege
 3.3.1.7 SELECT Privilege
 3.3.1.8 UPDATE privilege
 3.3.2 Index Privileges
 3.3.3 Sequence Privileges
 3.3.4 Schema privileges
 3.3.4.1 CREATIN Privilege
 3.3.4.2 ALTERIN Privilege
 3.3.4.3 DROPIN Privilege
 3.3.5 Package privileges
 Offline Data Unloading/Loading

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.