Re: Unload Table Data to Flat Files
- From: Jared Still <jkstill@xxxxxxxxx>
- To: dc4oracle@xxxxxxxxx
- Date: Wed, 16 Nov 2005 13:03:09 -0500
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@xxxxxxxxx> 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@xxxxxxxxxxxx>* 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.
> >
>
>
> >
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> ------------------------------
> Yahoo! FareChase - Search multiple travel sites in one
> click.<http://us.lrd.yahoo.com/_ylc=X3oDMTFqODRtdXQ4BF9TAzMyOTc1MDIEX3MDOTY2ODgxNjkEcG9zAzEEc2VjA21haWwtZm9vdGVyBHNsawNmYw--/SIG=110oav78o/**http%3a//farechase.yahoo.com/>
>
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
