RE: Loading strings longer than 255

From: Tirumala, Surendra HS <surendra.tirumala_at_hs.utc.com>
Date: Thu, 12 Oct 2000 09:07:39 -0400
Message-Id: <10647.119059@fatcity.com>

I am not sure how to increase the buffer size.But one of my friends suggested that you can overcome the loading probs by using Direct path = load

Surendra Tirumala
Oracle DBA
860-654-1322 (work)
860-298-9141 (home)

> -----Original Message-----
> From: Blum, Marc [SMTP:blum_at_soptim.de]
> Sent: Thursday, October 12, 2000 5:41 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Loading strings longer than 255

>=20

> Dear all,

>=20
> we're loading charakter delimited data, were one field is larger than =
255.
> Now SQL*Loader has a default maximum length for delimited data of =
255.
> Does
> anybody knows how to increase this limit?

>=20

> Thanx in advance

>=20
>=20

> Freundliche Gr=FC=DFe

>=20

> Marc Blum

>=20

> SOPTIM GmbH
> Gr=FCner Weg 22-24
> D-52070 Aachen

>=20


> Telefon:	+49 241 / 9 18 79-33

> Fax:	+49 241 / 15 40 38

>=20

> mailto:marc.blum_at_soptim.de
> http://www.soptim.de

>=20
>=20

> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: Blum, Marc
> INET: blum_at_soptim.de

>=20


> 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).
Received on Thu Oct 12 2000 - 08:07:39 CDT