Message-Id: <10700.123567@fatcity.com> From: Alex Hillman Date: Mon, 4 Dec 2000 15:21:54 -0500 Subject: 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_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@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@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@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" RE: Problem Importing

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

Alex Hillman

-----Original Message-----
From: Rocky Welch [mailto:rockyw_99@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@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@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).