Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> import fails due to different character set

import fails due to different character set

From: Kota, Raghu <Raghu.Kota_at_CIBC.ca>
Date: Wed, 8 Feb 2006 17:30:33 -0500
Message-ID: <E3809BA2C8091D4E8F69381BD20772B104B9A723@WMMCC-C2-MEU01.na.corp.cibcwm.com>

 

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.  

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 08 2006 - 16:30:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US