import fails due to different character set

  • From: "Kota, Raghu" <Raghu.Kota@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 8 Feb 2006 17:30:33 -0500

 

Hi Guys,

 

Could any body suggest workaround to import data from database charset
WE8ISO8859P1 to database charset UTF8, Here it is my error!

 

import server uses UTF8 character set (possible charset conversion)

export client uses WE8ISO8859P1 character set (possible charset
conversion)

. importing RAMSTG's objects into RAMSTG

. . . importing table           "CLASS_REC"

IMP-00019: row rejected due to ORACLE error 12899

IMP-00003: ORACLE error 12899 encountered

ORA-12899: value too large for column
"RAMSTG"."CLASS_REC"."LEGAL_LAST_NAME" (actual: 22, maximum: 20)

Column : 1051003

 

Thanks

Raghu.

 

Other related posts: