Maximum spool filesize under HPUX 11 / Oracle 8.0.6

Greetings,

I am creating a spool file in Oracle Sql*Plus (SQL*Plus: Release 8.0.6.0.0) under HP-UX 11.

My script contains a single select statement that is spooling millions of records in formatted output and has a whenever statement at the top:

    whenever oserror exit oserror

The script is called from a shell (ksh) script, and Sql*Plus returns an error message after running for some hours:

    O/S Message: File too large

My shell script grabs the return code ($?) from this job:

10/10/2001 14:56: [ERROR] RunSqlScript(): Load of </blah/blah.sql> failed -- Error Code <139>

I cannot find Unix code 139 in /usr/include/sys/errno.h

Although I did find
#define EFBIG 27 /* File too large */

My questions are:
(1) What is the maximum file size a user process can create in HP-UX 11
(2) Where can I see where this is defined and how do I change it
(3) What is the error code that Sql*Plus returned to the shell (via $?)
(4) In my log the following message appeared:
"O/S Message: File too large" over 10,000 times yet i have the

   whenever oserror exit oserror
clause at the top of my script -- why didn't it exit immediately?

Thanks in advance for any information. Received on Wed Oct 10 2001 - 02:09:39 CDT