Have a look at the error message - it is "value too large for column". UTF8 is a mult-byte characterset while the older WE8..P1 is a single byte characterset. In the LEGAL_LAST_NAME column, you have one or more rows which has at least one or more special characters which expands from the WE8 single byte entry to occupy a UTF8 double (or multi-byte) entry. You will have to expand the LEGAL_LAST_NAME column to accomodate this expansion.
And while you are it, you might as well expand those other columns which may possibly hold special characters. This is especially true for Name columns...
Hth, John Kanagaraj <>< DB Soft Inc Phone: 408-970-7002 (W)
** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Kota, Raghu Sent: Wednesday, February 08, 2006 2:31 PM To: oracle-l@(protected) Subject: import fails due to different character set
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 (See ORA-12899.ora-code.com): value too large for column "RAMSTG"."CLASS_REC"."LEGAL_LAST_NAME" (actual: 22, maximum: 20)
Column : 1051003
Thanks
Raghu.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word"><HEAD><TITLE>ODBC connection - extra statements being run</TITLE> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2900.2802" name=GENERATOR> <STYLE>@(protected) Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline } A:visited { COLOR: purple; TEXT-DECORATION: underline } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline } P { FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto } SPAN.EmailStyle18 { COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=EN-US vLink=purple link=blue> <DIV dir=ltr align=left><SPAN class=464123422-08022006><FONT face=Arial color=#0000ff size=2>Raghu,</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=464123422-08022006><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=464123422-08022006><FONT face=Arial color=#0000ff size=2>Have a look at the error message - it is "value too large for column". UTF8 is a mult-byte characterset while the older WE8..P1 is a single byte characterset. In the LEGAL_LAST_NAME column, you have one or more rows which has at least one or more special characters which expands from the WE8 single byte entry to occupy a UTF8 double (or multi-byte) entry. You will have to expand the LEGAL_LAST_NAME column to accomodate this expansion.</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=464123422-08022006><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=464123422-08022006><FONT face=Arial color=#0000ff size=2>And while you are it, you might as well expand those other columns which may possibly hold special characters. This is especially true for Name columns...</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=464123422-08022006><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=464123422-08022006><FONT face=Arial color=#0000ff size=2>Hth,</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=464123422-08022006> <DIV align=left><FONT face=Arial size=2>John Kanagaraj <><<BR>DB Soft Inc<BR>Phone: 408-970-7002 (W)</FONT></DIV> <DIV><FONT face=Arial size=2></FONT> </DIV> <DIV align=left><FONT face=Arial size=2>Co-Author: Oracle Database 10g Insider Solutions</FONT></DIV> <DIV align=left><FONT face=Arial size=2><U><FONT color=#0000ff size=2>http://www.amazon.com/exec/obidos/tg/detail/-/0672327910/</U></FONT>< /FONT></DIV> <DIV align=left> <DIV align=left><FONT face=Arial size=2></FONT> </DIV> <DIV align=left><FONT face=Arial size=2>** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **</FONT></DIV></DIV></SPAN></DIV><BR> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Kota, Raghu<BR><B>Sent:</B> Wednesday, February 08, 2006 2:31 PM<BR><B>To:</B> oracle-l@(protected)<BR><B>Subject:</B> import fails due to different character set<BR></FONT><BR></DIV> <DIV></DIV> <DIV class=Section1> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>< /SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi Guys,<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>< /SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Could any body suggest workaround to import data from database charset WE8ISO8859P1 to database charset UTF8, Here it is my error!<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>< /SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">import server uses UTF8 character set (possible charset conversion)<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">export client uses WE8ISO8859P1 character set (possible charset conversion)<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">. importing RAMSTG's objects into RAMSTG<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">. . . importing table "CLASS_REC"<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">IMP-00019: row rejected due to ORACLE error 12899<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">IMP-00003: ORACLE error 12899 encountered<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">ORA-12899 (See ORA-12899.ora-code.com): value too large for column "RAMSTG"."CLASS_REC"."LEGAL_LAST_NAME" (actual: 22, maximum: 20)<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Column : 1051003<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>< /SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Thanks<o:p></o:p>< /SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Raghu.<o:p></o:p>< /SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p>< /SPAN></FONT></P></DIV></BODY></HTML>
