Re: SPOOL Problem

Thanks a lot.
I will try UTL_FILE.
I "unload" data to feed a linux-based program. That program uses text files as input and I cannot modify it :( .
I'm now reading http://asktom.oracle.com/~tkyte/flat/index.html. It seems a useful solution.

BTW, I tried to search on Metalink. There's no hits.

On 6/7/06, Graeme.Farmer_at_mincom.com <Graeme.Farmer_at_mincom.com> wrote:
>
> You would probably be best to write a PL/SQL procedure to achieve this
> making use of UTL_FILE to write directly to a file rather than via the SPOOL
> mechanism in SQL*Plus.
>
>
>
> Using PL/SQL gives the ability to perform BULK fetches from the source
> data too which can significantly improve performance.
>
>
>
> If you look hard enough, you will probably find some code on the web that
> will unload to CSV or SQL*Loader format text files.
>
>
>
> What is the purpose of writing the tables to text file? Do you need to
> archive the data in a portable format? Loading data to another system?
> Different platform/rdbms?
>
>
>
> Cheers
>
> * *
>
> *Graeme Farmer *
>

-- 
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog:  http://spaces.msn.com/members/yaoyp/

--
http://www.freelists.org/webpage/oracle-l