Re: best way to export Oracle table into a text file?

From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1996/11/19
Message-ID: <329209AB.3FD0_at_charlie.cns.iit.edu>#1/1


Igor wrote:
>
> I'm looking to easiest ( and free ) way to export Oracle table as a TEXT
> file ( in a format 1 row/line, several K rows, each row <100 chars).
> Any suggestions/scripts/programs etc will be appreciated
>
> Igor
You can do this in couple of ways. One is spool the table to a text file (formatted sql report) and the other option is through MS ACCESS using ODBC.
Hope this helps

-- 
  AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
  ORACLE CONSULTANT
  WHITTMAN-HART CORPORATION
  CHICAGO.
Received on Tue Nov 19 1996 - 00:00:00 CET

Original text of this message