Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents

1 Overview of Migrating Databases to Unicode

• What Is a Database Character Set?
• Introduction to Character Set Migration
• Why Unicode Is the Right Choice
• About Character Set Migration Tools
  • Identifying Migration Issues with the Database Character Set Scanner
  • Changing Character Set Metadata Using the CSALTER Script
  • Converting Character Data Using the Export/Import and Data Pump Utilities
    • Full Versus Selective Export/Import
    • Data Pump Utility
    • Conversion Issues
  • Migrating a Database Using the Database Migration Assistant for Unicode
• Overview of Character Set Migration Considerations
  • Character Set Migration: Data Integrity
    • Data Expansion
    • Invalid Binary Storage Representation of Data
    • Partitioning
    • Maximum Index Key Size
    • Unique Keys and Primary Keys
    • Derived or Encrypted Data
    • Character Data Stored in Binary Data Types
  • Character Set Migration: Dependent Objects
  • Character Set Migration: Read-Only and Inaccessible Objects
  • Character Set Migration: Downtime
  • Character Set Migration: Failure Recovery
  • Character Set Migration: Application Impact

2 Getting Started with the DMU

• Using the Database Migration Assistant for Unicode: A Roadmap
• Introduction to the DMU Interface and Navigation
• Overview of Requirements and Security Considerations
  • Overview of Database Requirements
  • Overview of Java Runtime Requirements
  • Overview of DMU Security Considerations
  • Review Your Preparations for Migration
• Performing First Tasks With the DMU
  • Installing the DMU
  • Creating a Database Connection
  • Installing the Migration Repository
  • Following the Status of the Migration
• Introduction to the DMU User Interface
• Overview of Data Preparation
  • Data Preparation: Scanning
  • Data Preparation: Cleansing
• Overview of Data Conversion
  • Preparing the Conversion
  • Converting Data

3 Viewing and Setting Object Properties in the DMU

• Viewing and Setting Database Properties
  • Database Properties: General
  • Database Properties: Scanning
  • Database Properties: Readiness
  • Database Properties: Converting
• Viewing and Setting Schema Properties
  • Schema Properties: General
  • Schema Properties: Scanning
  • Schema Properties: Readiness
• Viewing and Setting Table Properties
  • Table Properties: General
  • Table Properties: Scanning
  • Table Properties: Readiness
  • Table Properties: Converting
• Viewing and Setting Column Properties
  • Column Properties: General
  • Column Properties: Scanning
  • Column Properties: Readiness
  • Column Properties: Converting

4 Performing Basic DMU Tasks

• Initializing the Database
  • Installing Required Patches
  • Installing Supporting Packages
  • Creating a Tablespace for the Migration Repository
  • Creating a Database Connection
• Refreshing the Migration Repository
• Uninstalling the Migration Repository
• Scanning the Database
  • Setting Database Properties
  • Scanning the Database with the Scan Wizard
  • Monitoring the Progress of a Scan
  • Viewing the Database Scan Report
  • Overview of the Database Scan Report
    • Database Scan Report: Result Grid
    • Database Scan Report: Navigating by Status Icons
    • Database Scan Report: Filtering
    • Database Scan Report: Searching
    • Database Scan Report: Exporting to HTML
• Cleansing the Data
• Converting the Database
  • Conversion Details Tab
  • Edit Table Conversion Plan Details Dialog
• Validating Data as Unicode
  • Introduction to the User Interface in Validation Mode
  • How to Validate Data

5 Advanced Topics in the DMU

• Excluding Columns and Tables From Migration
• Handling Non-Accessible Data
  • Read-Only Tables Considerations
  • Read-Only Tablespaces Considerations
  • Offline Tablespaces and Data Files Considerations
  • Working With External Tables
    • Cleansing External Tables
    • Cleansing Length Issues
    • Correcting Character Set Declaration of ORACLE_LOADER Files
    • Correcting Character Set Declaration of ORACLE_DATAPUMP Files
    • Fixing Corrupted Character Codes
    • Handling Binary Data
    • Performance Considerations for ORACLE_LOADER Files
• Migrating Data Dictionary Contents
  • Scanning Data Dictionary Tables
  • Cleansing Data Dictionary Tables
    • Cleansing Data Length Issues
    • Cleansing Invalid Binary Representation Issues
    • Identifying Metadata
  • Converting Data Dictionary Tables
  • Data Dictionary Tables That Are Ignored
  • Handling Automatic Workload Repository Tables
• Working with Multilingual Columns
• Advanced Convertibility Issues
  • Convertibility Issues: Uniqueness Validation
  • Convertibility Issues: Index Size
  • Convertibility Issues: Partition Range Integrity
  • Convertibility Issues: Objects in the Recycle Bin
  • Convertibility Issues: PL/SQL Local Identifiers Greater Than 30 Bytes
• Adapting Applications for Unicode Migration
  • Running Legacy Applications Unchanged
  • Changes to SQL and PL/SQL Code

6 Using the DMU to Cleanse Data

• Cleansing Data
  • Cleansing Data: Using the Toolbar
  • Cleansing Data: Color Highlighting
  • Filtering Data
    • Filtering on Convertibility Status
    • Filtering on SQL Condition
  • Setting the Assumed Character Set
• Viewing Data
• Editing Data
• Displaying Data
• Modifying Columns
• Scheduling Column Modification
• Modifying Attributes
• Scheduling Attribute Modification
• Ignoring Convertibility Issues
• Cleansing Scenario 1: A Database with No Issues
• Cleansing Scenario 2: Cleansing Expansion Issues
  • Over Column Limit Issues
    • Lengthening a Column
    • Changing the Length Semantics
    • Shortening Character Values Manually
    • Truncating Column Values During Conversion
    • Replacing Expanding Characters
    • Migrating to a Larger Data Type
  • Handling Over Type Limit Issues
  • Refreshing Scan Results
  • Revoking Scheduled Cleansing Actions
• Cleansing Scenario 3: Cleansing Invalid Representation Issues
  • Cleansing Binary Values in Character Columns
  • Cleansing Incorrect Character Set Declaration
  • Cleansing Corrupted Character Values

Glossary