Re: HELP: writing data to flat files from Oracle

joe17836_at_my-deja.com wrote:

> Is there any way to write data to a flat file from an Oracle database
> besides using "spool" or the utl_file package in PL/SQL? Anyone know
> why Oracle doesn't provide a utility like SQLLoader (SQL UN-Loader?)
> for writing to flat files? Both "spool" and utl_file seem pretty slow.
>

Kill the terminal I/O and you will find that spool is a lot faster than you think.
Also you should download an unloader utility from either Jared Sitll or Thomas Kytes web site.

hth

>
> Thanks!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Once I figured out how to spell DBA I became one -- Jerry Gitomer Received on Wed Dec 22 1999 - 23:19:15 CST