Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing TAB-delimited data
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