Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sqlldr problem
I have a control file as below:
load data
infile 'zprod_rev.dmp'
append into table zprod_rev
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY "*text"(
reviewid,reviewbody char(64000),rating)
The reviewbody has a lot of carriage returns and sql loader takes each one of them as new rows and eventually exceeds the error limits. How do I tell sql loader not to take carriage returns as new rows or define something like *row as row delimiter.
Thanks,
SP
Received on Mon Feb 11 2002 - 16:00:01 CST