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 -> sqlldr problem

sqlldr problem

From: Sunil Pant <spant_at_eline.com>
Date: Mon, 11 Feb 2002 22:00:01 GMT
Message-ID: <B9X98.1257$1F2.22083@sea-read.news.verio.net>


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

Original text of this message

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