Re: ASCII export

SPOOL should work, but do this first:

set linesize 2000 (or some reasonable length for what you want) set trimspool on
set feedback off

(and any other settings that you want to set that will affect the output).

-Matt

<craibuc_at_my-deja.com> wrote in message news:8s7gf0$uc2$1_at_nnrp1.deja.com...
> 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?
>
> Thanks,
>
> Craig B.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Oct 15 2000 - 19:28:10 CEST