I am importing a data dump of 11g database in 19c version using Impdp command. During the import I am getting the following message:
"Master table "SYS"."SYS_IMPORT_FULL_17" successfully loaded/unloaded
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
Warning: possible data loss in character set conversions"
Due to this error I am not able to import some of very important tables and it is showing the following error:
"ORA-02374: conversion error loading table "DWH"."GBLT_LOGIN_UNSUCESSFUL_LOG"
ORA-12899: value too large for column GSTR_LOGINID (actual: 28, maximum: 20)
ORA-02372: data for row: GSTR_LOGINID : 0X'554443483137303120BFBFBFBFBFBFBFBF204361'"
I believe the above error is due to character set conversion error. Kindly suggest any solution!