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:
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.
?/rdbms/admin/prvtdumi.plb
If not you will get following error:
Then you can complete DMU repository creation:
Now your database is ready for SCAN:
Wait till scanning completes then right click the connection name and choose “Database Scan Report”
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:
Now you will notice no migration issues observed after scanning database.
Now your database is ready for characterset migration:-)
Done!!!!!!!!!!
Hope so u will find this post very useful 🙂
Cheers
Regards,
Adityanath
Categories: 12c, Administration, Advanced features
Adityanath's Oracle Blog 
I like this blog so much, saved to bookmarks.
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
woh I like your posts, saved to fav! .
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
you are my inspiration , I have few web logs and often run out from to post : (.
Great post, you have pointed out some wonderful points, I also believe this s a very excellent website.
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!
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.
Hi there, I check your new stuff on a regular basis.
Your writing style is witty, keep up the good work!
I am impressed with this web site, very I am a fan.
thank you for sharing with us, I conceive this website genuinely stands out : D.
I could not refrain from commenting. Exceptionally well written!
Hi there, I enjoy reading through your article.
I wanted to write a little comment to support you.
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.
I appreciate you sharing this post.
Appreciate it for sharing the information with us.
Appreciate it for sharing the information with us.
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.
It’s best to participate in a contest for probably the greatest blogs on the web. I will recommend this site!
Great information. Lucky me I discovered your blog by accident (stumbleupon). I have saved as a favorite for later!
very interesting topic, great post.
I discovered your blog website on google and check several of your early posts. Continue to keep the top notch operate. I additional increase your Feed to my MSN News Reader. Seeking toward reading a lot more of your stuff at a later time!…
I am really pleased to glance at this website posts which consists of plenty
of useful data, thanks for providing such information.
A round of applause for your article post.Much thanks again. Want more.
What’s up mates, nice post and fastidious urging commented
here, I am genuinely enjoying by these.
I absolutely love your blog.. Great colors & theme.
Did you develop this amazing site yourself? Please reply back as I’m trying to create
my own blog and want to find out where you got this from or exactly what the theme is named.
Thanks!
This website was… how do I say it? Relevant!! Finally I have
found something that helped me. Kudos!
As I website owner I believe the articles here is really fantastic , thankyou for your efforts.
Wow! This can be one particular of the most beneficial blogs We’ve ever arrive across on this subject. Basically Wonderful. I’m also an expert in this topic therefore I can understand your effort.
Marvelous, what a webpage it is! This webpage provides useful information to us, keep
it up.