DMU – Characterset Migration

Data Migration Assistant for Unicode (DMU) 19.1 is available

Just for those of you who face a character set migration challenge, the Data Migration Assistant for Unicode (DMU) 19.1 is available now for download.

Data Migration Assistant for Unicode (DMU) 19.1 is available

What is the DMU?

Oracle Database Migration Assistant for Unicode (DMU) is a tool for migrating your databases from legacy encodings to Unicode. It simplifies the migration process. You as the DBA should need less experience and knowledge – and it should ease your task. It automates many steps. The migration happens in-place and reduces the effort and downtime required for data conversion, comparing to conventional export and import migration methods. You can also use …

Continue reading...

Can you select a PDB’s character set?

Can you select a PDB's character set?Since Oracle Database 12.2.0.1 a Multitenant container database can host PDBs with different character sets. This was a huge restriction in Oracle Database 12.1., at least outside the US and Canada. Here in Germany alone you may find plenty of different database character sets, for instance WE8ISO8859P1, WE8ISO8859P9, WE8ISO8859P15, WE8MSWIN1252, maybe still some old WE8DEC – and of course the unicode ones UTF8 and AL32UTF8. But the question is: Can you select a PDB’s character set when you provision a new PDB?

Mixing PDB character sets in Oracle Database 12.2.

One of the limiting restrictions in Oracle 12.1 Multitenant …

Continue reading...

DMU – Tips and Tricks – Migration Assistant for Unicode

DMU OTN Logo

Please find previous posts about the Data Migration Assistant for Unicode (DMU) here:


Since Roy and I subscribed to the Hot Topics support email we’ll find a very helpful note none of us was aware of almost every second day.

One of these recent finds is:

For those who have never heard of the DMU before you’ll find a very …

Continue reading...

Migrating to Unicode? Get DMU 2.1!

DMU OTN LogoWhen you find yourself needing to perform a character set migration as part of a database upgrade or migration, the Oracle Database Migration Assistant for Unicode (DMU) is a very helpful tool. It will assess your migration needs and help automate the process, all with a very nice GUI front end that makes the whole process easier.

And now comes a really nice enhancement with DMU 2.1: automation of near-zero downtime character set migration! Here is the blurb from the DMU OTN page:

New! Oracle DMU 2.1, released in May 2015, supports a near-zero downtime migration model in conjunction

Continue reading...