Re: SPOOL Problem
- From: "Yongping Yao" <yaoyongping@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 7 Jun 2006 18:34:29 +0800
Well, I've solved the problem without SQL*Plus. There is a very useful post
on ASKTom:
[url]http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:459020243348[/url]
There's the source code for a Pro*C solution. You can compile it yourself.
But I add a new line to include <SQLCA.H>. I don't know if the code is not
complete for Oracle 9i. It works. And I complete unloading an 8GB text file
in less than an hour. ^_^
On 6/7/06, Yongping Yao <yaoyongping@xxxxxxxxx> wrote:
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<http://asktom.oracle.com/%7Etkyte/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@xxxxxxxxxx <Graeme.Farmer@xxxxxxxxxx> 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/
--
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog: http://spaces.msn.com/members/yaoyp/
Other related posts:
