Re: Unload Table Data to Flat Files
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: dc4oracle@xxxxxxxxx
- Date: Wed, 16 Nov 2005 15:08:45 +0100
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
Other related posts:
