Re: load with carriage return

From: Mark Malakanov <markmal_no_spam_at_home.com>
Date: Sun, 27 Jan 2002 17:46:22 GMT
Message-ID: <3C543D89.4080008@home.com>

You can specify the length of row.
You can specify the length of every field ( in binary format )

You can replace CR with other character before loading. Translate back after.

Mark

Thierry wrote:

> Hi,
>
> I have to load (with SQL*Loader) a text file with fields VARCHAR2
> the text field has carriage return in it so the load failed ...
>
> How can I load this file ?????
>
> Thanks for your help
>
> conf: WNT 4.0 Oracle 8.1.6,7
>
>
>
Received on Sun Jan 27 2002 - 11:46:22 CST