Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

RE: Problem Importing

From: Lewis, Ed <>
Date: Tue, 5 Dec 2000 08:33:32 -0500
Message-Id: <>


	I've experienced this problem on
	Solaris 2.7, and Oracle
	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

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

From: Rocky Welch [] 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?


Rocky Welch
Senior Consultant - Internet Services Group Arthur Andersen

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.

Please see the official ORACLE-L FAQ:

Author: Rocky Welch
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: (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 Received on Tue Dec 05 2000 - 07:33:32 CST

Original text of this message