RE: Problem Importing

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Mon, 4 Dec 2000 15:21:54 -0500
Message-Id: <10700.123567@fatcity.com>

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_01C05E2F.D7C62980

Content-Type: text/plain;

charset="iso-8859-1"

Why init.ora? Make a buffer parameter for imp utility =1000000.

Alex Hillman

-----Original Message-----

From: Rocky Welch [mailto:rockyw_99_at_yahoo.com] Sent: Monday, December 04, 2000 12:55 PM To: Multiple recipients of list ORACLE-L Subject: Problem Importing

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

Rocky Welch
Senior Consultant - Internet Services Group Arthur Andersen

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rocky Welch
INET: rockyw_99_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: 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).

------_=_NextPart_001_01C05E2F.D7C62980

Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: Problem Importing</TITLE>
</HEAD>
<BODY>

Why init.ora? Make a buffer parameter for imp utility =1000000.

Alex Hillman

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Rocky Welch [<A HREF="mailto:rockyw_99_at_yahoo.com">mailto:rockyw_99_at_yahoo.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, December 04, 2000 12:55 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Problem Importing</FONT>
</P>
<BR>

<P><FONT SIZE=2>Hi Gang,</FONT>
<BR><FONT SIZE=2>I'm receiving the following error on a Solaris 2.8 with Oracle 8.1.6 and</FONT>

2gig memory:

IMP-00020: long column too large for column buffer size (40)

The error action in the documentation says this:

<P><FONT SIZE=2>Cause: The column buffer is too small. This usually occurs when importing</FONT>
<BR><FONT SIZE=2>LONG data. </FONT>
</P>

<P><FONT SIZE=2>Action: Increase the insert buffer size 10,000 bytes at a time up to</FONT>
<BR><FONT SIZE=2>66,000 or greater (for example). Use this step-by-step approach because a</FONT>

buffer size that is too large may cause a similar problem.

<P><FONT SIZE=2>Following the recommendation didn't help. It doesn't seem to matter what</FONT>
<BR><FONT SIZE=2>value I put in I always get the same message. I was able to import the</FONT>
<BR><FONT SIZE=2>same table on an NT database with smaller init.ora settings. Any ideas?</FONT>
</P>

<P><FONT SIZE=2>TIA,</FONT>
<BR><FONT SIZE=2>-Rocky</FONT>

<P><FONT SIZE=2>=====</FONT>
<BR><FONT SIZE=2>Rocky Welch</FONT>
<BR><FONT SIZE=2>Senior Consultant - Internet Services Group</FONT>
<BR><FONT SIZE=2>Arthur Andersen</FONT>
</P>

<P><FONT SIZE=2>__________________________________________________</FONT>
<BR><FONT SIZE=2>Do You Yahoo!?</FONT>
<BR><FONT SIZE=2>Yahoo! Shopping - Thousands of Stores. Millions of Products.</FONT>
<BR><FONT SIZE=2>http://shopping.yahoo.com/</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Rocky Welch</FONT>

INET: rockyw_99_at_yahoo.com

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>

Received on Mon Dec 04 2000 - 14:21:54 CST