Have you tried increasing the -Xmx value in the script - setHPenv.bat
I think it is set as -Xmx512M so try -Xmx1024M or higher to see if it exports more records
Wow, a reply from two Oracle Aces within minutes! Thank you Celvin and John. You guys are AWESOME. I set to '-Xmx1024M' as suggested and no more heap errors for moi.
P.S. Another exciting fact -- I also learned the correct pronunciation of my colleague's first name today. Pronounce Celvin with a soft C like 'celcius.'
Successfully logged into "Plan1" application, Release 11.121, Adapter Interface Version 5, Workforce supported and not enabled, CapEx not supported and not enabled, CSS Version 3
[Mon Oct 14 11:27:51 EDT 2013]Input file member load ordering option (/O switch) will not be performed: this option is not available for the "JobCode" dimension.
[Mon Oct 14 11:27:51 EDT 2013]Successfully opened export file "Plan1-JobCode_exp.csv".
[Mon Oct 14 11:28:03 EDT 2013]A cube refresh operation will not be performed.
[Mon Oct 14 11:28:03 EDT 2013]Create security filters operation will not be performed.
[Mon Oct 14 11:28:03 EDT 2013]Examine the Essbase log files for status if Essbase data was loaded.
[Mon Oct 14 11:28:03 EDT 2013]Planning Outline data store load process finished. 11818 export records were written.