Re: Exporting ASCII Text file

From: Vadim Grepan <kezal_at_mail.ru>
Date: Fri, 02 Feb 2001 17:40:08 +0300
Message-ID: <3A7AC6C8.AAEDEE6E@mail.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
  Received on Fri Feb 02 2001 - 08:40:08 CST