Re: Exporting Oracle table to a plain ASCII file

From: Edward J. Prochak <edprochak_at_interfacefamily.com>
Date: Fri, 28 Aug 1998 23:26:47 -0400
Message-ID: <35E774F7.8E9B8F27@interfacefamily.com>

Consider just using the SQLPLUS spool command and SQL*LOADER.

OUTPUT- script looks like:

set header off
REM might also need to set linesize and pagesize spool data.file
select * from your_table;
spool off
exit

INPUT- you need the SQL*LOADER control file and the data file from above.
I don't have my manual handy, but it's easy to set up a fixed sized fields script.

Alan (achristie_at_wei.org) wrote:
>
> I would like to know if an utility exists to dump the contents of an Oracle
> table to a plain ASCII file. If so, where can I get this utility? It would
> be ideal if this utility is bi-directional, i.e. Oracle table to an ASCII
> file and vice versa. I am aware of an IMPORT type command to populate a
> table with an ascii file, but the EXPORT command appears to use a special
> file (non-ASCII)
>
> Any suggestions?
>
Received on Fri Aug 28 1998 - 22:26:47 CDT