Hi i'm doing an export and import i'm getting some error.
IMP-00019: row rejected due to ORACLE error 1401
IMP-00003: ORACLE error 1401 encountered
ORA-01401: inserted value too large for column
Column 1 10
Column 2 E06BPT00014A
Column 3 EDP Produção - Gestão de Produção de Energia, S.A.
Column 4 Eng. Ricardo
Column 5 BCUIUS0001
Column 6 19-FEB-2004:01:55:18
Column 7 <OLDDATA><REGISTRATION_NUMBER=E06BPT00014A><COMPAN...
Column 8 <NEWDATA><REGISTRATION_NUMBER=E06BPT00014A><COMPAN...
Column 9 1
Column 10 1256
Column 11
Column 12
IMP-00019: row rejected due to ORACLE error 1401
IMP-00003: ORACLE error 1401 encountered
ORA-01401: inserted value too large for column
Column 1 10
Column 2 E016PT00552C
Column 3 APEB - ASSOC. PORTUG. DAS EMPRESAS DE BETÃO PRONTO
Column 4 G. CARLOS
Column 5 LFILES0001
Column 6 27-APR-2004:09:39:20
Column 7 <OLDDATA><REGISTRATION_NUMBER=E016PT00552C><COMPAN...
Column 8 <NEWDATA><REGISTRATION_NUMBER=E016PT00552C><COMPAN...
Column 9 1
Column 10 1687
Column 11
Column 12
Structure is same. The character set is diffrent is this problem how can i resolve this?
Source
--------
NLS_CHARACTERSET -- WE8ISO8859P1 -- Character set
Destination
--------------
NLS_CHARACTERSET-- AL32UTF8 --Character set
regds,
Thomas.