Unload Table Data to Flat Files
- From: d cheng <dc4oracle@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 16 Nov 2005 04:31:29 -0800 (PST)
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. Below are the SQL*Plus settings in effect when the extraction SQL statement was issued. If I 'set wrap on', I will see all the data for the varchar column but they are split on multiple lines - I need them to be on a single line. set wrap off set linesize 32767 set trimspool on set feedback off set pagesize 0 set verify off set termout off spool test.sql select c1||chr(199)|| c2||chr(199)|| n3||chr(199)|| c4||chr(199)|| d5||chr(199)|| n6 from my_table spool off; Thank you in advance for your help! - David --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.