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: Spool Question

Re: Spool Question

From: cumin <jkilbourne_at_gmail.com>
Date: 11 Dec 2006 12:17:53 -0800
Message-ID: <1165868273.223444.69820@73g2000cwn.googlegroups.com>

CriticalJ_at_gmail.com wrote:
> I have been asked to export some oracle tables to text files. The main
> problem I am having is the resulting file.
>
> The sql for the requested fields is stuck at the top of the file and
> spool off is at the bottom.
>
> I have used Set ECHO OFF at the top of the command as well as several
> other set commands but nothing seems to stop this.
>
> The solution is probably easy but I am not a regular Oracle user so it
> is eluding me. If anyone could direct me to a solution, I would
> appreciate it greatly.
>
> Thank you.

I use Tom Kyte's method to make text files: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:68212348056 Received on Mon Dec 11 2006 - 14:17:53 CST

Original text of this message

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