I have a database in Oracle 8.1.7 with characterset ZHT16MSWIN950, and I need to migrate this database to Oracle 220.127.116.11 with characterset WE8MSWIN1252.
I think there's something wrong.
The character set ZHT16MSWIN950 is for Traditional Chinese and is encoded in Multibytes (I think 2 Bytes), while WE8MSWIN1252 is encoded in 1 Byte.
So you cannot do this conversion without loosing characters.
You should migrate to UNICODE (AL32UTF8), this link may help you:
You'll have also some interesting reference here:
Hope this help,
Did you use character set scanner to foresight character set change issues?
You need to use Unicode to keep all info. Confirming AL32UTF8 is recommended by Oracle.
Consider this is a 4 bytes character set so your target database would be bigger.
If you keep the source character set first and migrate to UTF8 as a second step you can use Database Migration Assistant for Unicode. Or you can do this migration manually as well.
But your export-import solutions should work just fine as well and this is one step only.
As another possible solution for you is to create database link between databases(source and target) and use SQL CONVERT function for cleanse / fix data issues. Aka do the migration manually.
Please note there are specific forums for these topics exists: