Re: Exporting ASCII Text file

Not sure what you mean.

If you want an ASCII representation of how on Earth to re-create the table, investigate the IMPORT options INDEXFILE=C:\BLAH.TXT and INDEX=N.

If you want a CSV version of the DATA in a table, try something like:

set head off termout off verify off feedback off echo off pagesize 0 spool commalist.csv
select empno || ',' || ename || ',' || job || ',' || mgr || ','|| hiredate from scott.emp;
spool off

And if you are after tab delimited data, then try this:

set head off termout off verify off feedback off echo off pagesize 0 spool tablist.txt
select empno || chr(9) || ename || chr(9) ||job || chr(9) || mgr || chr(9) || hiredate from scott.emp;
spool off

Regards
HJR "Rob Diaz" <rdiaz_at_ebudgets.com> wrote in message news:lHye6.893$Zp3.90475_at_e3500-chi1.usenetserver.com...
> How does one go about exporting an ASCII text file representation of a
 table
> from Oracle 8? (specifically, 8.0.6). We need this file to be able to
> import again (eventually) using sql*loader, as well as excel and other
> tools.
>
> Thanks in advance!
> Rob
>
>
Received on Fri Feb 02 2001 - 08:39:24 CST