Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SPOOL Problem
Well, I want to "unload" a table to text file( or files, as I do now, just
to keep each file small). That would be more than 10 GB. There is some tools
to do it, but they run on Windows( for instance, Golden has a good tool to
"unload", TOAD has some memory problem too. ).
On 6/7/06, Graeme.Farmer_at_mincom.com <Graeme.Farmer_at_mincom.com> wrote:
>
> I would expect that it is an SQL*Plus bug as this is the program that is
> responsible for accepting the data from the RDBMS and outputting it to file.
> (The fact that the realloc system call is unhandled would indicate to me
> that the memory allocation routine is not being tested which is certainly a
> bug).
>
>
>
> Typically a program would read the incoming data (from the RDBMS) into a
> buffer and then writing from that buffer to the output destination (eg
> terminal/disk file).
>
>
>
> If memory is continuously being allocated to increase the size of the
> buffer but it is not being released then this leads to a memory leak.
>
>
>
> Of course, there could be another reason for your problem so best to raise
> a TAR and have the guys that write the software give you the definitive
> answer. To be honest, I've never tried creating a spool file that large and
> it may be that the developers of SQL*Plus didn't anticipate users would have
> this requirement either!
>
>
>
> What are you actually trying to achieve, there may be an alternative
> solution?
>
>
>
> 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-lReceived on Tue Jun 06 2006 - 22:25:34 CDT