Re: SQLLDR problem
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 16 Jul 2008 23:01:32 +0200
Message-ID: <487E61AC.8040807@gmail.com>
Date: Wed, 16 Jul 2008 23:01:32 +0200
Message-ID: <487E61AC.8040807@gmail.com>
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 Received on Wed Jul 16 2008 - 16:01:32 CDT