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

------_=_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>

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 [<A = HREF=3D"mailto:Ed_Lewis_at_PremierInc.com">mailto:Ed_Lewis_at_PremierInc.com</= A>]

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

Hi,
         I've = experienced this problem on
         Solaris = 2.7, and Oracle 8.1.6.2.
         On the = export script,I changed

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

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

&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><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>

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?

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

Arthur Andersen

<FONT =

SIZE=3D2>__________________________________________________</FONT>

Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of = Products.
 <A HREF=3D"http://shopping.yahoo.com/" = TARGET=3D"_blank">http://shopping.yahoo.com/</A> -- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

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

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

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

-----

 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: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

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

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