Forum Stats

  • 3,769,714 Users
  • 2,253,014 Discussions


How to solve Character set conversion error!

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!


Best Answer


This discussion has been closed.