Database - RAC/Scalability (MOSC)

MOSC Banner

IMPDP with portuguese characters

edited Dec 6, 2017 4:02AM in Database - RAC/Scalability (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center