Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP: writing data to flat files from Oracle

Re: HELP: writing data to flat files from Oracle

From: <joe17836_at_my-deja.com>
Date: Thu, 23 Dec 1999 17:56:16 GMT
Message-ID: <83tnmb$pc3$1@nnrp1.deja.com>


In article <3861B0D3.38AB1D64_at_erols.com>,   Jerry Gitomer <jgitomer_at_erols.com> wrote:
> 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
>

I have killed the terminal I/O. Thanks for the other suggestions.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 23 1999 - 11:56:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US