Break New Ground

  • June 23, 2014

Need to Migrate Oracle 12C Pluggable Databases to Unicode Character Set?

Laura Ramsey
Manager, Oracle Database Developer Communities


After a weekend of phenomenal World Cup Soccer matches,  this is a good day to think about Globalization.  

Here's what you need to know: Oracle Database Migration Assistant for Unicode (DMU) 2.0 is the officially supported method for migrating Oracle 12c Pluggable Databases (PDBs) to the Unicode character set. Oracle DMU also supports migrating selected prior releases of Oracle Database 10.2, 11.1 and 11.2.


Here's what's interesting:  Migration to the Unicode character set is an intricate process that involves many time-consuming and resource intensive operations. Any misstep along the way can lead to data loss. Oracle DMU provides an end-to-end workflow that guides the DBA through a detailed and customizable migration process with real-time progress updates. Additional recovery and diagnostic mechanisms enable a fault-tolerant migration in the event of runtime contingencies.

Other new features in Oracle DMU 2.0 include:

  • Support for Unicode 6.1, a major version of the Unicode standard that supersedes all previous versions of the standard; and support for new locales.
  • New features include support for unicode Collation Algorithm as fully detailed in the Oracle Database Globalization Support Guide section entitled "Linguistic Sorting and Matching". 
  • Enhanced bulk cleansing features with pattern-based replacement to resolve certain classes of data convertibility issues.
  • Support for migrating PeopleSoft databases to Unicode.
  • Improved conversion error-handling mechanisms.

If you need a technical overview about character set migration, migration tools and considerations including benefits of Unicode, check out the Indepth Guide to Migrating Databases to Unicode.


Anything else you need to know about Oracle DMU 2.0?  Go to the Oracle DMU page on OTN

Ciao for now!




Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.