Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing TAB-delimited data
You can also put TERMINATED BY ' ' in your sql*loader control file
where
you type a TAB inbetween the quotes - although the CHR(9) is neater.
NetComrade wrote:
> 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 Wed Dec 15 1999 - 14:36:07 CST