Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Spool Question
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
![]() |
![]() |