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: Importing TAB-delimited data

Re: Importing TAB-delimited data

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Fri, 17 Dec 1999 16:16:24 -0500
Message-ID: <385aa846@defiant.btitelecom.net>


Ue the following statement in your sqlldr control file: fields terminated by X'09'

NetComrade wrote in message <3857c338.76058942_at_news.earthlink.net>...
>Any advice on how I can import TAB delimited file into Oracle?
>I cannot use DELIMITED BY WHITESPACE b/c
>
>If TERMINATED BY WHITESPACE is specified, data is read until the first
>occurrence of a whitespace character (space, tab, newline). Then the
>current position is advanced until no more adjacent whitespace
>characters are found. This allows field values to be delimited by
>varying amounts of whitespace
>
>but my street column will surely have whitespaces
>
>I tried doing this thru Access (it has the Tab-delimited feature), but
>got ODBC call failed (maybe b/c it's too large or something, its like
>200K records)
>
>Thanx.
>---------------
>Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Fri Dec 17 1999 - 15:16:24 CST

Original text of this message

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