From: Vadim Grepan <kezal@mail.ru>
Newsgroups: comp.databases.oracle.server
Subject: Re: Exporting ASCII Text file
Date: Fri, 02 Feb 2001 17:40:08 +0300
Organization: 2:5020/653@fidonet.org
Lines: 24
Message-ID: <3A7AC6C8.AAEDEE6E@mail.ru>
References: <lHye6.893$Zp3.90475@e3500-chi1.usenetserver.com>
NNTP-Posting-Host: 195.68.177.53
Mime-Version: 1.0
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit
X-Trace: josh.sovintel.ru 981125190 83856 195.68.177.53 (2 Feb 2001 14:46:30 GMT)
X-Complaints-To: usenet@news.sovintel.ru
NNTP-Posting-Date: 2 Feb 2001 14:46:30 GMT
X-Mailer: Mozilla 4.74 [en] (WinNT; U)
X-Accept-Language: ru


Hello!

   Simplest way:

    SQL>    set pagesize 1000000
    SQL>    spool exp.dat
    SQL>    select fld1||'|'||fld2||'|'||fld3 from tbl_xxx;
        ..
    SQL>    spool off

Rgds, Vadim Grepan
-------------------------------------
Moscow, Russia

Rob Diaz wrote:

> 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