Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1)

Database Migration Assistant for Unicode (DMU) in Oracle Database 12c Release 1 (12.1)

What is Oracle Database Migration Assistant for Unicode?

Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode. DMU's intuitive user-interface greatly simplifies the migration process and lessens the need for character set migration expertise by guiding the DBA through the entire migration process as well as automating many of the migration tasks. It comes with a scalable in-place migration architecture which significantly reduces the effort and downtime required for data conversion, comparing to conventional export and import migration methods. For post-migration and existing databases already using the Unicode character set, the DMU also has a validation mode, in which it identifies data not correctly encoded in Unicode, thus providing a health check on potential issues with implementation of Unicode in database applications.

The Database Migration Assistant for Unicode (DMU) is listed as a 12c new feature, but it is actually a separate tool that supports a number of different database versions.

• Download
• Prepare
• Migrate
• Tidy Up

Download

Version 1.2 of the DMU is shipped with the 12c database. You can see it by running the following commands.

$ cd $ORACLE_HOME/dmu

$ sh dmu.sh

Prepare

Make sure the SYS.DBMS_DUMA_INTERNAL package is installed.

$ sqlplus / as sysdba

SQL> @?/rdbms/admin/prvtdumi.plb

Library created.

Package created.

No errors.

Package body created.

No errors.

SQL>

We are now ready to start the migration.

$ export JAVA_HOME=$ORACLE_HOME/jdk

$ cd $ORACLE_HOME/dmu/

$ sh dmu.sh

Right-click on the "Databases" node in the Navigator pane and select the "New Database Connection" option from the popup menu.