1/9
Contents
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction
2
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.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.3.7
IBM DB2 Datalinks
2.3.8
User-Defined Distinct Data Types
2.3.9
IBM DB2 Structured Data Types
3
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
4
Offline Data Loading
4.1
Script Directory Structure
4.2
Unloading Data from an IBM DB2 Database
4.2.1
Procedure to Unload Data from an IBM DB2 Database
4.3
Loading Data into an Oracle database
4.3.1
Procedure to Unload Data from the IBM DB2 Database
4.3.1.1
SQL*Loader Control File
Index
Scripting on this page enhances content navigation, but does not change the content in any way.