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
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