IMPDP with portuguese characters
Hi Community,
When importing data with impdp for a DB version 12.2, we get a lot of errors like the following.:
ORA-02374: conversion error loading table "SAPE"."CONTACTOS"
ORA-12899: value too large for column SALAID (actual: 7, maximum: 6)
In fact all the inserts with values containing portuguese characters, with length equal to column lengths, are failing.
The expdp was made from a PDB version 12.2 with WE8DEC character set.
The problem seems to be the character set conversion to AS32UTF8, the character set we are using in the target PDB
In the Solaris environment, before begining the imbdp, we have: NLS_LANG=PORTUGUESE_PORTUGAL.AL32UTF8