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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem Importing

RE: Problem Importing

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Wed, 6 Dec 2000 19:40:16 -0500
Message-Id: <10702.123879@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_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



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

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

Author: Lewis, Ed
  INET: Ed_Lewis_at_PremierInc.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_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">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0">
<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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>I've = experienced this problem on</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>Solaris = 2.7, and Oracle 8.1.6.2.</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>On the = export script,I changed </FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>the =
&quot;direct=3Dy&quot; to &quot;direct=3Dn&quot;,</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>to use =
the conventional path.</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>Then, the = import worked fine.</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>The = export in this case was a </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT = SIZE=3D2>&quot;full&quot; one.</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>I went = through the same ritual</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>that you = did, increasing the buffer</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>size, but = that did not work.</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>I = contacted Oracle support, and they</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>had me = try numerous combinations of</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT = SIZE=3D2>export/import. When doing </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>a = &quot;direct&quot; export on a single table,</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>and then = doing the import that seemed</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>to work. =
</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>The =
bottom line for me, is that I must</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>use a = conventional export for now,to</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>guarantee = that the import will work.</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>The = performance suffers but it works.</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2>But my = original problem still remains</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT = SIZE=3D2>unresolved.</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <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><A HREF=3D"http://shopping.yahoo.com/" = TARGET=3D"_blank">http://shopping.yahoo.com/</A></FONT> <BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Rocky Welch</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: rockyw_99_at_yahoo.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) = 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =

SIZE=3D2>---------------------------------------------------------------=

-----</FONT>

<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information = (like subscribing).</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Lewis, Ed</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Ed_Lewis_at_PremierInc.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) = 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =

SIZE=3D2>---------------------------------------------------------------=

-----</FONT>

<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = Received on Wed Dec 06 2000 - 18:40:16 CST

Original text of this message

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