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 got…

DMU – Tips and Tricks – Migration Assistant for Unicode

Please find previous posts about the Data Migration Assistant for Unicode (DMU) here: We included the DMU into our slide deck a while ago: Upgrade, Migrate & Consolidate to Oracle Database 12c . Migrating to Unicode? Get DMU 2.1! 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: MOS Note:2018250.1 Tips and Known Issues – Database Migration Assistant for Unicode (DMU) 2.1 For those who have never heard of the DMU before you’ll find a very…

Migrating to Unicode? Get DMU 2.1!

When 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 with the…