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