Message-Id: <10702.123879@fatcity.com> From: Alex Hillman Date: Wed, 6 Dec 2000 19:40:16 -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_01C05FE6.44BD6690 Content-Type: text/plain; charset="iso-8859-1" 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@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 ===== 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lewis, Ed INET: Ed_Lewis@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@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_01C05FE6.44BD6690 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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@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=3Dy" to "direct=3Dn",
        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


=3D=3D=3D=3D=3D
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lewis, Ed
  INET: Ed_Lewis@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@fatcity.com (note EXACT spelling of = 'ListGuru') and in
the message BODY, include a line containing: UNSUB =