Go to main content
1/12
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Overview of Migrating Databases to Unicode
1.1
What Is a Database Character Set?
1.2
Introduction to Character Set Migration
1.3
Why Unicode Is the Right Choice
1.4
About Character Set Migration Tools
1.4.1
Identifying Migration Issues with the Database Character Set Scanner (CSSCAN)
1.4.2
Changing Character Set Metadata Using the CSALTER Script
1.4.3
Converting Character Data Using the Export/Import and Data Pump Utilities
1.4.3.1
Full Versus Selective Export/Import
1.4.3.2
Data Pump Utility
1.4.3.3
Conversion Issues
1.4.4
Migrating a Database Using the Database Migration Assistant for Unicode
1.5
Overview of Character Set Migration Considerations
1.5.1
Character Set Migration: Data Integrity
1.5.1.1
Data Expansion
1.5.1.2
Invalid Binary Storage Representation of Data
1.5.1.3
Partitioning
1.5.1.4
Maximum Index Key Size
1.5.1.5
Unique Keys and Primary Keys
1.5.1.6
Derived or Encrypted Data
1.5.1.7
Character Data Stored in Binary Data Types
1.5.2
Character Set Migration: Dependent Objects
1.5.3
Character Set Migration: Read-Only and Inaccessible Objects
1.5.4
Character Set Migration: Downtime
1.5.5
Character Set Migration: Failure Recovery
1.5.6
Character Set Migration: Application Impact
2
Getting Started with the DMU
2.1
Using the Database Migration Assistant for Unicode: A Roadmap
2.2
Introduction to the DMU Interface and Navigation
2.3
Overview of Requirements and Security Considerations
2.3.1
Overview of Database Requirements
2.3.2
Overview of Java Runtime Requirements
2.3.3
Overview of DMU Security Considerations
2.3.4
Review Your Preparations for Migration
2.4
Performing First Tasks With the DMU
2.4.1
Installing the DMU
2.4.2
Creating a Database Connection
2.4.3
Installing the Migration Repository
2.4.4
Following the Status of the Migration
2.5
Introduction to the DMU User Interface
2.6
Overview of Data Preparation
2.6.1
Data Preparation: Scanning
2.6.2
Data Preparation: Cleansing
2.7
Overview of Data Conversion
2.7.1
Preparing the Conversion
2.7.2
Converting Data
3
Viewing and Setting Object Properties in the DMU
3.1
Viewing and Setting Database Properties
3.1.1
Database Properties: General
3.1.2
Database Properties: Scanning
3.1.3
Database Properties: Readiness
3.1.4
Database Properties: Converting
3.2
Viewing and Setting Schema Properties
3.2.1
Schema Properties: General
3.2.2
Schema Properties: Scanning
3.2.3
Schema Properties: Readiness
3.3
Viewing and Setting Table Properties
3.3.1
Table Properties: General
3.3.2
Table Properties: Scanning
3.3.3
Table Properties: Readiness
3.3.4
Table Properties: Converting
3.4
Viewing and Setting Column Properties
3.4.1
Column Properties: General
3.4.2
Column Properties: Scanning
3.4.3
Column Properties: Readiness
3.4.4
Column Properties: Converting
4
Performing Basic DMU Tasks
4.1
Initializing the Database
4.1.1
Installing Required Patches
4.1.2
Installing Supporting Packages
4.1.3
Creating a Tablespace for the Migration Repository
4.1.4
Creating a Database Connection
4.2
Refreshing, Reinstalling, Upgrading, and Uninstalling the Migration Repository
4.2.1
Refreshing the Migration Repository
4.2.2
Reinstalling the Migration Repository
4.2.3
Upgrading the Migration Repository
4.2.4
Uninstalling the Migration Repository
4.3
Scanning the Database
4.3.1
Setting Database Properties
4.3.2
Scanning the Database with the Scan Wizard
4.3.3
Monitoring the Progress of a Scan
4.3.4
Viewing the Database Scan Report
4.3.5
Overview of the Database Scan Report
4.3.5.1
Database Scan Report: Result Grid
4.3.5.2
Database Scan Report: Navigating by Status Icons
4.3.5.3
Database Scan Report: Filtering
4.3.5.4
Database Scan Report: Searching
4.3.5.5
Database Scan Report: Exporting to HTML
4.3.5.6
Database Scan Report: Stopping the Scan
4.3.6
Generating the Problem Data Report
4.4
Cleansing the Data
4.5
Converting the Database
4.5.1
Conversion Details Tab
4.5.2
Edit Table Conversion Plan Details Dialog
4.5.3
Stopping a Conversion
4.6
Validating Data as Unicode
4.6.1
Introduction to the User Interface in Validation Mode
4.6.2
How to Validate Data
4.7
Creating a Diagnostic Package
5
Advanced Topics in the DMU
5.1
Excluding Columns and Tables From Migration
5.2
Handling Non-Accessible Data
5.2.1
Read-Only Tables Considerations
5.2.2
Read-Only Tablespaces Considerations
5.2.3
Offline Tablespaces and Data Files Considerations
5.2.4
Working With External Tables
5.2.4.1
Cleansing External Tables
5.2.4.2
Cleansing Length Issues
5.2.4.3
Correcting Character Set Declaration of ORACLE_LOADER Files
5.2.4.4
Correcting Character Set Declaration of ORACLE_DATAPUMP Files
5.2.4.5
Fixing Corrupted Character Codes
5.2.4.6
Handling Binary Data
5.2.4.7
Performance Considerations for ORACLE_LOADER Files
5.3
Migrating Data Dictionary Contents
5.3.1
Scanning Data Dictionary Tables
5.3.2
Cleansing Data Dictionary Tables
5.3.2.1
Cleansing Data Length Issues
5.3.2.2
Cleansing Invalid Binary Representation Issues
5.3.2.3
Identifying Metadata
5.3.3
Converting Data Dictionary Tables
5.3.4
Data Dictionary Tables That Are Ignored
5.3.5
Handling Automatic Workload Repository Tables
5.4
Working with Multilingual Columns
5.5
Advanced Convertibility Issues
5.5.1
Convertibility Issues: Uniqueness Validation
5.5.2
Convertibility Issues: Index Size
5.5.3
Convertibility Issues: Partition Range Integrity
5.5.4
Convertibility Issues: Objects in the Recycle Bin
5.5.5
Convertibility Issues: PL/SQL Local Identifiers Greater Than 30 Bytes
5.6
Adapting Applications for Unicode Migration
5.6.1
Running Legacy Applications Unchanged
5.6.2
Changes to SQL and PL/SQL Code
5.7
Exporting and Importing Migration Profile
5.7.1
Exporting a Migration Profile
5.7.2
Importing a Migration Profile
5.8
Near-Zero Downtime Database Migration to Unicode
5.9
Repairing Database Character Set Metadata
5.9.1
Example: Using CSREPAIR
5.10
Updating the DMU Version
5.11
DMU Accessibility Information
5.11.1
Using a Screen Reader and Java Access Bridge with the DMU
6
Using the DMU to Cleanse Data
6.1
Cleansing Data
6.1.1
Cleansing Data: Using the Toolbar
6.1.2
Cleansing Data: Color Highlighting
6.1.3
Filtering Data
6.1.3.1
Filtering on Convertibility Status
6.1.3.2
Filtering on SQL Condition
6.1.4
Setting the Assumed Character Set
6.2
Viewing Data
6.3
Editing Data
6.4
Displaying Data
6.5
Modifying Columns
6.6
Scheduling Column Modification
6.7
Modifying Attributes
6.8
Scheduling Attribute Modification
6.9
Ignoring Convertibility Issues
6.10
Bulk Cleansing
6.10.1
Bulk Cleansing Data from Byte Semantics to Character Semantics
6.10.2
Bulk Cleansing Data by Allowing Conversion of Data with Issues
6.10.3
Bulk Cleansing Data with Pattern-Based Replacement
6.10.4
Bulk Cleansing Examples
6.11
Cleansing Scenario 1: A Database with No Issues
6.12
Cleansing Scenario 2: Cleansing Expansion Issues
6.12.1
Over Column Limit Issues
6.12.1.1
Lengthening a Column
6.12.1.2
Changing the Length Semantics
6.12.1.3
Shortening Character Values Manually
6.12.1.4
Truncating Column Values During Conversion
6.12.1.5
Replacing Expanding Characters
6.12.1.6
Migrating to a Larger Data Type
6.12.2
Handling Over Type Limit Issues
6.12.3
Refreshing Scan Results
6.12.4
Revoking Scheduled Cleansing Actions
6.13
Cleansing Scenario 3: Cleansing Invalid Representation Issues
6.13.1
Cleansing Binary Values in Character Columns
6.13.2
Cleansing Incorrect Character Set Declaration
6.13.3
Cleansing Corrupted Character Values
A
Third-Party License Information
Glossary
Index
Scripting on this page enhances content navigation, but does not change the content in any way.