Thanks, Alex. But as you see below I tried all kinds of numbers, including
the one you suggested for imp buffers, and it didn't work.
- Alex Hillman <alex_hillman_at_physia.com> wrote:
> Why init.ora? Make a buffer parameter for imp utility =1000000.
>
> Alex Hillman
>
> -----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).
>
Rocky Welch
Senior Consultant - Internet Services Group
Arthur Andersen
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Received on Mon Dec 04 2000 - 15:03:11 CST