How to Migrate characterset of 12c database using Database Migration Assistant for Unicode (DMU) Tool

This post will help you to convert characterset of database from WE8ISO8859P15 to AL32UTF8 in 12C. From 12c you will need to use DMU tool for characterset conversion instead of traditional method of CSSCAN & CSALTER. DMU is the Database Migration Assistant for Unicode . It converts the NLS_CHARACTERSET of an existing database to AL32UTF8 or UTF8.

DMU divides coversion into 4 steps:

1. Install DMU repository.
2. Scan the database.
3. Resolve the migration issues.
4. Convert the database.

Once DMU is started, you will need to create database connection as given below:

dmu1 dmu2

So as to make use of DMU, you need to create DBMS_DUMA_INTERNAL package under SYS schema. For creating mentioned package, you need to run following script.


If not you will get following error:


Then you can complete DMU repository creation:

dmu4 dmu5 dmu6 dmu7



Now your database is ready for SCAN:






Wait till scanning completes then right click the connection name and choose “Database Scan Report”

dmu16 dmu17 dmu18

Once you get results, you need to tackle invalid representations & Over column limit issues.

For invalid representations, you will need to right click a table and choose “Cleansing Editor”. The characters with issues will appear as small squares. You can edit data so as to fix invalid representations.

For over column limit, you will need to use bulk cleansing option as shown below:

dmu22 dmu23 dmu23 dmu24 dmu25 dmu26 dmu27 dmu28

Now you will notice no migration issues observed after scanning database.


Now your database is ready for characterset migration:-)

dmu30 dmu31 dmu32 dmu33


Hope so u will find this post very useful 🙂




20 replies

  1. Great post, you have pointed out some wonderful points, I also believe this s a very excellent website.

  2. Thank you for this great website. I am trying to read some more posts but I cant get your blog to display properly in my Firefox Browser. Thank you again!

  3. Howdy I am so happy I found your blog page, I really
    found you by error, while I was searching on Bing for something else, Anyways I am here now
    and would just like to say kudos for a incredible post and a all round entertaining blog (I also love the theme/design), I don’t have time to browse it all at the minute but
    I have bookmarked it and also included your RSS feeds,
    so when I have time I will be back to read more, Please do
    keep up the superb job.

  4. I’m often to blogging and i really respect your content. The article has actually peaks my interest. I’m going to bookmark your web site and maintain checking for brand spanking new information.

  5. Thank you for sharing excellent informations. Your web-site is so cool. I’m impressed by the details that you have on this blog. It reveals how nicely you perceive this subject. Bookmarked this website page, will come back for more articles. You, my pal, ROCK! I found simply the information I already searched everywhere and simply could not come across. What a great site.

Leave a Reply to Anonymous Cancel reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s