From: "Howard J. Rogers" <howardjr@www.com>
Newsgroups: comp.databases.oracle.server
References: <lHye6.893$Zp3.90475@e3500-chi1.usenetserver.com>
Subject: Re: Exporting ASCII Text file
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
X-Original-NNTP-Posting-Host: 203.134.155.91
Message-ID: <3a7ac695@news.iprimus.com.au>
X-Original-Trace: 3 Feb 2001 01:39:17 +1100, 203.134.155.91
Date: Sat, 3 Feb 2001 01:39:24 +1100
NNTP-Posting-Host: 203.134.64.67
X-Trace: news0.optus.net.au 981124761 203.134.64.67 (Sat, 03 Feb 2001 01:39:21 EST)
NNTP-Posting-Date: Sat, 03 Feb 2001 01:39:21 EST
Organization: CWO Customer - reports relating to abuse should be sent to abuse@cwo.net.au


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@ebudgets.com> wrote in message
news:lHye6.893$Zp3.90475@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
>
>