Re: Unload Table Data to Flat Files

  • From: d cheng <dc4oracle@xxxxxxxxx>
  • To: g_vikas@xxxxxxxxxxx, sfaroult@xxxxxxxxxxxx
  • Date: Wed, 16 Nov 2005 12:11:09 -0800 (PST)

Thank you Vikas!

Vikas Gautam <g_vikas@xxxxxxxxxxx> wrote:  We put our record seperator as a 
chr(111) or some unprintable character in 
the unload and the load and that solved the ^M problem.

Vikas

----- Original Message ----- 
From: "Stephane Faroult" 
To: 
Cc: 
Sent: Wednesday, November 16, 2005 8:08 AM
Subject: Re: Unload Table Data to Flat Files


> David,
>
> Can't you apply a replace(colname, chr(10), chr(32)) to your varchar2
> columns ?
> It should (normally) fix the issue.
>
> HTH
>
> Stéphane Faroult
>
> On Wed, 2005-11-16 at 04:31 -0800, d cheng wrote:
>> Hi Listers,
>>
>> I need to unload several large database tables unto flat files on a
>> Unix database server. I am using Tom Kyte's SQL*Plus unloader.
>> However, there seems to be a problem when a varchar column contains a
>> ^M (CR) within it. All other columns to the right of this are
>> truncated and missing from the record in the flat file. Is there a
>> way to workaround this truncation issue? I would like to NOT scrub
>> the data by removing the carriage return as the end-users might expect
>> them to be there.
>>
>
>
>>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> 
--
//www.freelists.org/webpage/oracle-l





                
---------------------------------
 Yahoo! FareChase - Search multiple travel sites in one click.  

Other related posts: