This discussion is archived
1 Reply Latest reply: Feb 21, 2012 7:53 PM by wzhang RSS

problem with migration to AL32UTF8

user5709846 Newbie
Currently Being Moderated
Hi,
I have a problem with character set migration to AL32UTF8 in Oracle database. My database version is 11.2.0.3 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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points