Re: exporting ASCII file from Oracle8

From: <mandrew_at_my-dejanews.com>
Date: 1998/05/28
Message-ID: <6kk6bl$kv7$1@nnrp1.dejanews.com>#1/1

In article <6khji2$qfb$1_at_nnrp1.dejanews.com>, mustafah_at_criticalsys.com wrote:
>
> I am trying to export specific columns from an Oracle8 table into an ASCII
> tab delimited file, I can't seem to find the utility that will perform this
> functionality. The utility has to be compatible with Oracle7.3 also.
>
> Another related question is: can I append the exported data to any existing
> ASCII file.
>
> Any suggestions are greatly appreciated.
>
> Thanks
> Mustafa
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

I encounter this problem a lot with the data warehouse. I prefer to use the MS Access approach using an Oracle 8 or 7 ODBC driver to connect. then Save As/Export into text file with the delimited options you desire. Very quick and very easy !

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 28 1998 - 00:00:00 CDT