SQLLDR problem
in [Oracle Help]
|
Prev: ORA-24334: no descriptor for this position
Next: paypal wholesale Christan Audigier shirt Coogi jeans(paypal accept)(www super- saler com
From: blindsey on 16 Jul 2008 16:51 I'm trying to import a fixed-length ASCII file using SQLLDR. The end-of-line is 0D 0A, as usual. But some notes fields in the data use 0D 0D 0A within them. SQLLDR interprets this as end-of-line. Is there a way I can tell SQLLDR to ignore that sequence or translate it into something else (like a space)?
From: Maxim Demenko on 16 Jul 2008 17:01 blindsey schrieb: > I'm trying to import a fixed-length ASCII file using SQLLDR. > > The end-of-line is 0D 0A, as usual. > > But some notes fields in the data use 0D 0D 0A within them. SQLLDR > interprets this as end-of-line. > > Is there a way I can tell SQLLDR to ignore that sequence or translate > it into something else (like a space)? Fixed record format? http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_concepts.htm#sthref472 Best regards Maxim
From: Laurenz Albe on 18 Jul 2008 02:36
Maxim Demenko <mdemenko(a)gmail.com> wrote: > blindsey schrieb: >> I'm trying to import a fixed-length ASCII file using SQLLDR. >> >> The end-of-line is 0D 0A, as usual. "As usual" is funny. >> But some notes fields in the data use 0D 0D 0A within them. SQLLDR >> interprets this as end-of-line. >> >> Is there a way I can tell SQLLDR to ignore that sequence or translate >> it into something else (like a space)? > > Fixed record format? Or surround the fields with quotes. Yours, Laurenz Albe |