Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

What You Should Already Know

How This Reference Guide is Organized

How to Use This Reference Guide

Documentation Accessibility

Accessibility of Code Examples in Documentation

Related Documentation

Conventions

1 Overview

Introduction to the Migration Workbench

2 Oracle and IBM DB2 UDB Compared

Data Storage Concepts

Oracle Data Storage Concepts

Database Schema Migration

Schema Object Similarities

Database Schema Object Names

Design Considerations

Data Types

Data Types in Oracle and IBM DB2 UDB

Character Data Types

Graphic Data Types

Numeric Data Types

Date Data Types

String Representation of Datetime Values

IBM DB2 UDB Datalinks

User-Defined Distinct Data types

IBM DB2 UDB Structured Data Types

3 Database Security

Database Security Migration

Mapping IBM DB2 UDB Groups and Users

Mapping IBM DB2 UDB Authorization Levels to Oracle

Mapping IBM DB2 UDB Privileges to Oracle

4 Offline Data Loading

Script Directory Structure

Generating Export Scripts

Unloading Data from an IBM DB2 UDB Database

Procedure to Unload Data from an IBM DB2 UDB Database

Loading Data into an Oracle database

Procedure to Unload Data from the IBM DB2 UDB Database

Index