Skip to Main Content

Oracle Database Discussions

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!

imdp error - Value too large for column

Ken18Oct 2 2022 — edited Oct 3 2022

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

Comments

asahide

Hi,
What is the Charset of Source and Target DB.
I think it can be avoided by using the same Charset.
Regards,

1 - 1

Post Details

Added on Oct 2 2022
1 comment
493 views