SPOOL Problem

From: Yongping Yao <yaoyongping_at_gmail.com>
Date: Wed, 7 Jun 2006 10:13:11 +0800
Message-ID: <706468990606061913m41b8f9c4uf0f04f2d98c3d6c8@mail.gmail.com>

Hi all,
I don't know if it's off topic, but I met it in SQLPlus. I SPOOLed the output into a text. When the file reached to GB, an exception "xrealloc: cannot reallocate 706258176 bytes (0 bytes allocated)" occurred. I tried again and again. Everytime the exception occurred with different file size. Sometime it was about 3G, sometime it's near 1G ( and of cource the number in the error is different everytime ).

-bash-2.05b$ uname -a

Linux zszj2 2.4.21-27.EL #1 Wed Dec 1 22:08:15 EST 2004 i686 i686 i386 GNU/Linux

That's my OS. I also tried on Solaris 8, just the same. So I think it's not a 32bitOS or 64bitOS problem. The database is 9.2.0.1. Have anyone met and solved it?
Thank you in advance.

--

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 Received on Tue Jun 06 2006 - 21:13:11 CDT