i have to migrate an schema from one of the DB instance with below char set
1 NLS_CHARACTERSET WE8MSWIN1252
2 NLS_NCHAR_CHARACTERSET AL16UTF16
to a database instance with below char set,
1 NLS_CHARACTERSET AL32UTF8
2 NLS_NCHAR_CHARACTERSET UTF8
will there be any data loss after migrating the schema?
what will be the effect?
If your database release/platform is supported by DMU, the best way is to run a DMU scan on your source instance to discover any potential data issues for migrating to AL32UTF8. You can then use DMU to cleanse the data exceptions and decide whether to migrate the database in-place with DMU or move to a separate instance depending on your requirements. Any reason why you want to change the NCHAR character set to UTF8?