Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> SQL*Loader into table
I have a flat file that contains tab separated data. I'm trying to load
this into an oracle table but running into trouble.
I can successfully get most of the records in BUT in some cases, there is a
CR/LF that splits the record onto
2 lines right before the last column.
ie.
data value 1<tab>data value2<tab>data value3<cr/lf>
data value 1<tab>data value2<cr/lf>
<tab>data value3<cr/lf>
In other cases, the data appears as this:
data value 1<tab>data value2<tab><cr>
<tab>data value3<cr/lf>
(Note, NO Linefeed).
I can't control the program that dumps the data. It runs on a PC, but doesn't appear to consistently dump the records, one per line, with a <Tab> between each column.
I was trying to get SQL*Loader to handle this file with the following CTL file, but it rejects the records.
Any suggestions?
LOAD DATA
INFILE LastUpdate.txt
BADFILE LastUpdate_bad.txt
DISCARDFILE LastUpdate_discard.txt
CONTINUEIF NEXT(1) = X'9'
INTO TABLE Last_Update REPLACE
fields terminated by X'9'
(
center,
title,
last_updated
)
Received on Thu Jun 15 2000 - 00:00:00 CDT