I am in the process of migrating a database from characterset we8mswin1252 to al32utf8. I ran the csscan and the report shows no lossy database but truncation and convertable data. This means that I need to do a full export change the column lengths, then migrate the db to al32utf8, then re-import.
Before I import, I need to truncate or delete all the data. I am afraid that I will be hit with all kind of constraint issues. I am not too familiar with the new impdb expdb commands. What is my best approach ?