Re: ASCII export

craibuc wrote at 13-Okt-00 18:23:21
on the subject "ASCII export":  

>What is the easiest way to export 50 Oracle 7.x tables to 50 separate
>ASCII files? I need to the files to be comma-delimited and include the
>full column names. I've tried Toad and DBArtisan, but they have
>limitations. I've tried SPOOL in SQL*Plus, but the columns wrap. Any
>ideas?

To avoid the wrapping you have to set LINESIZE in SQL*Plus to a value big enough to hold the entire row of your table. Maybe in this case, setting TRIMSPOOL to ON is quite a good idea because it massively reduces the size of your spoolfiles.

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | lothar.armbruester_at_rheingau.vistec.net
Hauptstr. 26            | la_at_oktagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de