REPOST: 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: <6$--$%%%%--__%%-_$@news.noc.cabal.int>

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

WAS CANCELLED BY =======: From: Mark Malakanov <markmal_no_spam_at_home.com> Control: cancel <3C543D89.4080008_at_home.com> Subject: cmsg cancel <3C543D89.4080008_at_home.com> Date: Mon, 28 Jan 2002 00:24:28 GMT Message-ID: <cancel.3C543D89.4080008_at_home.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!cert.uni-stuttgart.de!news.belwue.de!news.uni-ulm.de!rz.uni-karlsruhe.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!newsfeed.vmunix.org!newsfeed.stueberl.de!newsfeed.r-kom.de!newsfeed.freenet.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40720345

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sun Jan 27 2002 - 11:46:22 CST