Skip to Main Content

LiveLabs & Workshops

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to solve Character set conversion error!

User_YGZU0Nov 9 2020

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!

This post has been answered by evgenyg on Nov 9 2020
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 7 2020
Added on Nov 9 2020
3 comments
8,882 views