Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

What You Should Already Know

Structure of this Guide

Using this Guide

Documentation Accessibility

Accessibility of Code Examples in Documentation

Related Documentation

Conventions

1 Overview

Introduction

Product Description

Features

Glossary

2 Migration Process

MySQL Architecture

Oracle Architecture

Triggers and Stored Procedures

PL/SQL Programming Language

Sequences

Transactions

Other Oracle Features

Preparing for Migration

Extending the Application

Using Offline Data Loading

Script Directory Structure

Generating mysqldump Data Extract Scripts

Using the Extracted Scripts

3 MySQL Data Types, Reserved Words, and Operators

Supported Oracle Data Types

Default Data Type Mappings

Comparing MySQL to Oracle

Numeric Types

Date and Time Types

String Types

Oracle Reserved Words

4 Troubleshooting

Defining the User Account

Dumping MySQL Data

Optimizing Command Line Options

A MySQL Error Messages

Error Messages

Index