Re: Unload Table Data to Flat Files

  • From: "Vikas Gautam" <g_vikas@xxxxxxxxxxx>
  • To: <sfaroult@xxxxxxxxxxxx>, <dc4oracle@xxxxxxxxx>
  • Date: Wed, 16 Nov 2005 13:40:29 -0600

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" <sfaroult@xxxxxxxxxxxx>
To: <dc4oracle@xxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2005