I have a problem with character set migration to AL32UTF8 in Oracle database. My database version is 188.8.131.52 and I’m using Database Migration Utility to Unicode. The most problematic thing is that I have two different chararacter sets in database. NLS_CHARSET is EE8ISO8859P2 and system data is in this charset, the second one is EE8MSWIN1250 and all application data is in that one because it was imported without conversion to ISO. I set in DMU that current charset is ISO, assumed is MSWIN and target is AL32UTF8. I managed to resolve all conflicts except for one – data in table SYS.SOURCE$ need conversion. I don’t know what to do with this one. Could someone help me with that? Is there another way to migrate database to UTF? Oracle support told me that using DMU tool is the only supported method.
Please check the "Converting Data Dictionary Tables" section in the DMU Guide:
DMU supports the conversion of sys.source$, except when the convertible data exists in object type definitions.