Re: SQLLOADER - wierd result
From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 07 Sep 2005 16:51:24 +0200
Message-ID: <431efe58$0$24146$9b4e6d93_at_newsread4.arcor-online.net>
Date: Wed, 07 Sep 2005 16:51:24 +0200
Message-ID: <431efe58$0$24146$9b4e6d93_at_newsread4.arcor-online.net>
[Quoted] Volker Pohlers schrieb:
> with simple csv files, sql loader supports only fields with a maximum
> length of 255 bytes.
>
> You must transfer your file into fixed length format. Here you can use
> full 4000 characters.
>
> Volker
That is not correct.
[Quoted] 255 is the default length for CHAR columns, which can of course be
overwritten by specifying the desired column width in the control file (
with respect for both, delimited or fixed length, data).
Best regards
Maxim Received on Wed Sep 07 2005 - 16:51:24 CEST