developers

    Forum Stats

  • 3,874,057 Users
  • 2,266,667 Discussions
  • 7,911,707 Comments

Discussions

imdp error - Value too large for column

Ken18
Ken18 Member Posts: 142 Red Ribbon
edited Oct 3, 2022 12:53PM in General Database Discussions

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

Answers

developers