Exporting Oracle table to a plain ASCII file

From: <achristie_at_wei.org>
Date: Fri, 28 Aug 1998 16:09:02 GMT
Message-ID: <6s6kmt$lmf$1@nnrp1.dejanews.com>

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?

I am using Oracle 7.3.3 on an AIX environment.

If no such utility exist I am thinking of coding my own in Embedded SQL/C,
(which may take awhile!)

Alan
achristienospam_at_wei.org
(remove the nospam to before you send it out)

or simply reply to this address

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 28 1998 - 11:09:02 CDT