Re: ASCII export

Can't you use UTL_FILE and write a generic routine to export to files? You could pass it a table name and it would just export a comma-delimited file. Probably take less than 2 hours coding.

<craibuc_at_my-deja.com> wrote in message news:8s7gho$uea$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 Sat Oct 14 2000 - 17:49:16 CDT