Handling lossy data before character- set migration I am trying to migrate a database from US7ASCII to AL32UTF8 using CSSCAN. During the initial scanning using CSSCAN we have found the presence of lossy data both in data dictionary() and application data.Can any one please help as to how can we handle the lossy data before converting database from US7ASCII to AL32UTF8 .

**USER.TABLE|COLUMN      LOSSY**

SYS.SOURCE$|SOURCE         143
Straight from the Manual:


  The easiest approach to migrating convertible data dictionary data is to create a new database in the target character set and then re-create all of the data dictionary and schema definitions by exporting and importing. However, this method means creating a new database.


Based on what I'm reading in this manual, that's hands-down the safest and easiest way to do this migration.