Re: Sql loader to load document

I had a similar problem while loading data. I resolved it by replacing all end of lines with a special charcater. Then after loading data into the Oracle database, ran a script to convert them to end of lines. Hope this helps.
-Kamala

In article <359BF3FB.329B_at_hp.com>,
  John Ma <john_ma_at_hp.com> wrote:
>
> Hi,
>
> In order to migrate from Paradox to Oracle, we need to load all data in
> Paradox into Oracle 7.3. The problem happens while trying to load
> "long" data.
>
> We have an article table contains article_id and article. article_id
> has datatype number and article has datatype "long". In varible length
> input text file, "$" is the field separator. But sql loader automatic
> treat "new line" is the separartor and treats the next paragraph in the
> article as the new record!!
>
> Does anyone knows how to resolve this problem? or I have done something
> wrong? Any information is greatly appreciated. Thank you very much.
>
> John
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 09 1998 - 09:13:25 CDT