Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr

Re: sqlldr

From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Wed, 21 Jul 1999 02:35:11 GMT
Message-ID: <zlal3.137$Cj6.39125@ratbert.tds.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US