Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Exporting Oracle table to a plain ASCII file
Take a look at Infomaker (Sybase). It's a reporting tool, but it includes a
very easy to use data pipeline that allows you to transfer data between any
2 databases. It uses native drivers for Oracle, but can also use ODBC.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
achristie_at_wei.org wrote in message <6s6kmt$lmf$1_at_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 Mon Aug 31 1998 - 10:41:02 CDT