Re: Unload Table Data to Flat Files

Thank you Jared!

Jared Still <jkstill_at_gmail.com> wrote: Sure, use a tool that converts data to hex codes, and recognizes   that when data is reloaded.    

  Typically (for USASCII7 data) anything less < char(32)   and > char(127) would be converted to hex.    

  Try googling for such a tool.    

  You might check and see if DataBee does this.    

  HTH       Jared  

  On 11/16/05, d cheng <dc4oracle_at_yahoo.com> wrote: Thank you for your suggestion. I am hesitant to scrub the chr(10) as it might change user's view of the data. The 'set wrap on' seemed to work ok except it produces an extra blank line - a side effect of setting wrap on?. Any suggestions on overcoming this extra blank line?

Stephane Faroult <sfaroult_at_roughsea.com> wrote: 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.
>

>

--
http://www.freelists.org/webpage/oracle-l





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





-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



		
---------------------------------
 Yahoo! FareChase - Search multiple travel sites in one click.  
--
http://www.freelists.org/webpage/oracle-l