imdp error - Value too large for column

Ken18

Hi Experts,

-> Frequent Table column conversion errors during import (impdp - 19c) .. same charecterset on source and target.

Same Database and schemas on Source and Target , still i see these errors while loading tables.

KUP-11007: conversion error loading table "xx_OWNER".."xx_xx"
ORA-12899: value too large for column xyz (actual: 34, maximum: 33)
KUP-11009: line data: LIBELLE_VOIE: 0X'564F4945204EB03620494E4E4F504F4C45205A414320475241'

why this occurs even if the source and target Databases and tables are same and its just the simple expdp and impdp.

How to avoid / fix this, do i need to alter modify my table column size ... is there a way to filter and direct all these to a file and update these columns.

• What are the best ways to avoid or fix these.
• And how to filter these using linux , like grep,awk etc to a file while excluding the know ora errors like object exists etc.

NOTE: I have also changed/set , max_string to extended - https://docs.oracle.com/database/121/REFRN/GUID-D424D23B-0933-425F-BC69-9C0E6724693C.htm#REFRN10321

asahide

Hi,

What is the Charset of Source and Target DB.

I think it can be avoided by using the same Charset.

Regards,