| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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_01C06071.ADAA72F6
Content-Type: text/plain;
charset="iso-8859-1"
Just want to add a something to my earlier comment. The tables that experienced the "long" error did NOT contain a long datatype.
-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com]
Sent: Wednesday, December 06, 2000 7:47 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Problem Importing
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
<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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.comReceived on Thu Dec 07 2000 - 11:18:24 CST
<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
<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_01C06071.ADAA72F6 Content-Type: text/html; charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Problem Importing</TITLE>
<META content="MSHTML 5.00.2722.2800" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=018491417-07122000>Just
want to add a something to my earlier</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=018491417-07122000>comment. The tables that experienced the "long" error</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=018491417-07122000>did
NOT contain a long datatype.</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Alex Hillman [mailto:alex_hillman_at_physia.com]<BR><B>Sent:</B> Wednesday, December 06, 2000 7:47 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Problem Importing<BR><BR></DIV></FONT> <P><FONT size=2>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=2>Alex Hillman</FONT> </P> <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Lewis, Ed [<A href="mailto:Ed_Lewis_at_PremierInc.com">mailto:Ed_Lewis_at_PremierInc.com</A>]</FONT> <BR><FONT size=2>Sent: Tuesday, December 05, 2000 8:36 AM</FONT> <BR><FONT size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT size=2>Subject: RE: Problem Importing</FONT> </P><BR> <P><FONT size=2>Hi,</FONT> <BR> <FONT size=2>I've experienced this problem on</FONT> <BR> <FONT size=2>Solaris 2.7, and Oracle 8.1.6.2.</FONT> <BR> <FONT size=2>On the export script,I changed </FONT><BR> <FONT size=2>the "direct=y" to "direct=n",</FONT> <BR> <FONT size=2>to use the conventional path.</FONT> <BR> <FONT size=2>Then, the import worked fine.</FONT> <BR> <FONT size=2>The export in this case was a </FONT><BR> <FONT size=2>"full" one.</FONT> <BR> <FONT size=2>I went through the same ritual</FONT> <BR> <FONT size=2>that you did, increasing the buffer</FONT> <BR> <FONT size=2>size, but that did not work.</FONT> <BR> <FONT size=2>I contacted Oracle support, and they</FONT> <BR> <FONT size=2>had me try numerous combinations of</FONT> <BR> <FONT size=2>export/import. When doing </FONT><BR> <FONT size=2>a "direct" export on a single table,</FONT> <BR> <FONT size=2>and then doing the import that seemed</FONT> <BR> <FONT size=2>to work. </FONT><BR> <FONT size=2>The bottom line for me, is that I must</FONT> <BR> <FONT size=2>use a conventional export for now,to</FONT> <BR> <FONT size=2>guarantee that the import will work.</FONT> <BR> <FONT size=2>The performance suffers but it works.</FONT> <BR> <FONT size=2>But my original problem still remains</FONT> <BR> <FONT size=2>unresolved.</FONT> <BR> <FONT size=2>ed</FONT> </P> <P><FONT size=2>-----Original Message-----</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> </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> <BR><FONT size=2>2gig memory:</FONT> </P> <P><FONT size=2>IMP-00020: long column too large for column buffer size (40)</FONT> </P> <P><FONT size=2>The error action in the documentation says this:</FONT> </P> <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> <BR><FONT size=2>buffer size that is too large may cause a similar problem. </FONT></P> <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><BR> <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><A href="http://shopping.yahoo.com/" target=_blank>http://shopping.yahoo.com/</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: Rocky Welch</FONT> <BR><FONT size=2> INET: rockyw_99_at_yahoo.com</FONT> </P> <P><FONT size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, California -- 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). You may</FONT> <BR><FONT size=2>also send the HELP command for other information (like subscribing).</FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Please see the official ORACLE-L FAQ: <A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com</A></FONT> <BR><FONT size=2>-- </FONT><BR><FONT size=2>Author: Lewis, Ed</FONT> <BR><FONT size=2> INET: Ed_Lewis_at_PremierInc.com</FONT> </P> <P><FONT size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, California -- 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
 |
 |