SPOOL Problem
- From: "Yongping Yao" <yaoyongping@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 7 Jun 2006 10:13:11 +0800
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/
Other related posts:
