Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr
SQL*Loader doesn't assume a variable length for character data. You can
"trick" it by using the directive: FIELDS TERMINATED BY ',' . That way it
will read to the end of the IP address looking for a comma and take the
entire field as IP instead of the first character.
Hope this helps.
Mike Morgan
wutang_warrior_at_my-deja.com wrote in message <7n1tur$rt3$1_at_nnrp1.deja.com>...
>Hello.
>
>My control file contains:
>-------------------------------
>load data infile 'za-networks'
>replace
>into table zanetworks
>(IP)
>-------------------------------
>
>The source file contains 2-3 octets each on a seperate line. (Class B's
>and C's)
>
>Only the first character is inserted into the table which is:
>-------------------------------------------------------------
>create table zanetworks (ip varchar2(11));
>-------------------------------------------------------------
>
>The log file says' "1" under Length.
>
>I've never had this problem and I can't figure it out.
>
>Any ideas?
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jul 20 1999 - 21:35:11 CDT