Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem Importing
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C05FE6.44BD6690
Content-Type: text/plain;
charset="iso-8859-1"
Next time when asking questions you should supply needed info. In this case this info is your parameters for export. Export in direct mode does not work with longs. It is in the docs.
Alex Hillman
-----Original Message-----
From: Lewis, Ed [mailto:Ed_Lewis_at_PremierInc.com]
Sent: Tuesday, December 05, 2000 8:36 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Problem Importing
Hi,
I've experienced this problem on Solaris 2.7, and Oracle 8.1.6.2. On the export script,I changed the "direct=y" to "direct=n", to use the conventional path. Then, the import worked fine. The export in this case was a "full" one. I went through the same ritual that you did, increasing the buffer size, but that did not work. I contacted Oracle support, and they had me try numerous combinations of export/import. When doing a "direct" export on a single table, and then doing the import that seemed to work. The bottom line for me, is that I must use a conventional export for now,to guarantee that the import will work. The performance suffers but it works. But my original problem still remains unresolved. ed
-----Original Message-----
Sent: Monday, December 04, 2000 12:55 PM
To: Multiple recipients of list ORACLE-L
Hi Gang,
I'm receiving the following error on a Solaris 2.8 with Oracle 8.1.6 and
2gig memory:
IMP-00020: long column too large for column buffer size (40)
The error action in the documentation says this:
Cause: The column buffer is too small. This usually occurs when importing LONG data.
Action: Increase the insert buffer size 10,000 bytes at a time up to 66,000 or greater (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem.
Following the recommendation didn't help. It doesn't seem to matter what value I put in I always get the same message. I was able to import the same table on an NT database with smaller init.ora settings. Any ideas?
TIA,
-Rocky
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
------_=_NextPart_001_01C05FE6.44BD6690
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Diso-8859-1">
<TITLE>RE: Problem Importing</TITLE> </HEAD> <BODY>
<P><FONT SIZE=3D2>Next time when asking questions you should supply = needed info. In this case this info is your parameters for export. = Export in direct mode does not work with longs. It is in the = docs.</FONT></P>
<P><FONT SIZE=3D2>Alex Hillman</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Lewis, Ed [<A = HREF=3D"mailto:Ed_Lewis_at_PremierInc.com">mailto:Ed_Lewis_at_PremierInc.com</= A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, December 05, 2000 8:36 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: Problem Importing</FONT> </P> <BR>
<P><FONT SIZE=3D2>Hi,</FONT>
<BR> <FONT SIZE=3D2>I've =
experienced this problem on</FONT>
<BR> <FONT SIZE=3D2>Solaris =
2.7, and Oracle 8.1.6.2.</FONT>
<BR> <FONT SIZE=3D2>On the =
export script,I changed </FONT>
<BR> <FONT SIZE=3D2>the = "direct=3Dy" to "direct=3Dn",</FONT> <BR> <FONT SIZE=3D2>to use =the conventional path.</FONT>
<BR> <FONT SIZE=3D2>to work. = </FONT> <BR> <FONT SIZE=3D2>The =bottom line for me, is that I must</FONT> <BR> <FONT SIZE=3D2>use a = conventional export for now,to</FONT>
= = <FONT SIZE=3D2>ed</FONT></P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>Sent: Monday, December 04, 2000 12:55 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> </P> <BR>
<P><FONT SIZE=3D2>Hi Gang,</FONT>
<BR><FONT SIZE=3D2>I'm receiving the following error on a Solaris 2.8 =
with Oracle 8.1.6 and</FONT>
<BR><FONT SIZE=3D2>2gig memory:</FONT>
</P>
<P><FONT SIZE=3D2>IMP-00020: long column too large for column buffer =
size (40)</FONT>
</P>
<P><FONT SIZE=3D2>The error action in the documentation says =
this:</FONT>
</P>
<P><FONT SIZE=3D2>Cause: The column buffer is too small. This usually =
occurs when importing</FONT>
<BR><FONT SIZE=3D2>LONG data. </FONT>
</P>
<P><FONT SIZE=3D2>Action: Increase the insert buffer size 10,000 bytes =
at a time up to</FONT>
<BR><FONT SIZE=3D2>66,000 or greater (for example). Use this =
step-by-step approach because a</FONT>
<BR><FONT SIZE=3D2>buffer size that is too large may cause a similar =
problem. </FONT>
</P>
<P><FONT SIZE=3D2>Following the recommendation didn't help. It doesn't =
seem to matter what</FONT>
<BR><FONT SIZE=3D2>value I put in I always get the same message. I was =
able to import the</FONT>
<BR><FONT SIZE=3D2>same table on an NT database with smaller init.ora =
settings. Any ideas?</FONT>
</P>
<P><FONT SIZE=3D2>TIA,</FONT> <BR><FONT SIZE=3D2>-Rocky</FONT> </P> <BR> <P><FONT SIZE=3D2>=3D=3D=3D=3D=3D</FONT> <BR><FONT SIZE=3D2>Rocky Welch</FONT> <BR><FONT SIZE=3D2>Senior Consultant - Internet Services Group</FONT><BR><FONT SIZE=3D2>Arthur Andersen</FONT> </P>
<P><FONT =
SIZE=3D2>__________________________________________________</FONT><BR><FONT SIZE=3D2>Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>Yahoo! Shopping - Thousands of Stores. Millions of = Products.</FONT>
<BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Rocky Welch</FONT> <BR><FONT SIZE=3D2> INET: rockyw_99_at_yahoo.com</FONT> </P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
<BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Lewis, Ed</FONT> <BR><FONT SIZE=3D2> INET: Ed_Lewis_at_PremierInc.com</FONT> </P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=