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/