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: <CriticalJ_at_gmail.com>
Date: 11 Dec 2006 12:21:36 -0800
Message-ID: <1165868495.960955.318500@j72g2000cwa.googlegroups.com>


Thanks. I'll look into this as well.

J
cumin wrote:
> 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:21:36 CST

Original text of this message

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