Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ASCII export

ASCII export

From: <craibuc_at_my-deja.com>
Date: Fri, 13 Oct 2000 17:23:21 GMT
Message-ID: <8s7ge0$ubi$1@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 Fri Oct 13 2000 - 12:23:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US