Oracle Solution for Error ora-34719

ORA-34719: (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion

What triggered the Error:

When character set conversion happens between TEXT and NTEXT either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.

What should we do to fix it:

Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE. Note: This message is the OLAP equivalent of ORA-12713.