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
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