Re: SQLLOADER - wierd result
From: Volker Pohlers <vpohlers_at_arcor.de>
Date: Wed, 14 Sep 2005 15:55:56 +0200
Message-ID: <43282bec$0$2119$9b4e6d93_at_newsread2.arcor-online.net>
>
>
> That is not correct.
> 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).
>
Date: Wed, 14 Sep 2005 15:55:56 +0200
Message-ID: <43282bec$0$2119$9b4e6d93_at_newsread2.arcor-online.net>
[Quoted] Maxim Demenko schrieb:
I found your answer tody, so I must reply:
>> 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.
> 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).
>
That is not correct.
[Quoted] Even if you declare a column as varchar2(4000), the sqlloader internally
uses in case of delimited data only 255 chars. You will get an
unassigned error message as "string too long" without an oracle error
number. Please, try it out.
Volker Received on Wed Sep 14 2005 - 15:55:56 CEST