Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-----
From: Rocky Welch [mailto:rockyw_99_at_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
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Received on Tue Dec 05 2000 - 07:33:32 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |