Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!intgwpad.nntp.telstra.net!wa.nnrp.telstra.net!news.cdn.telstra.com.au!not-for-mail From: [Encrypted] Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools,comp.sys.hp.hpux,comp.sys.hp.misc Subject: Maximum spool filesize under HPUX 11 / Oracle 8.0.6 Date: Wed, 10 Oct 2001 17:09:39 +1000 Organization: Basket Weavers, Anonymous. Lines: 37 Message-ID: Reply-To: franklynrizzo@today.com.au NNTP-Posting-Host: 144.131.155.99 X-Trace: news.cdn.telstra.com.au 1002697792 22289 144.131.155.99 (10 Oct 2001 07:09:52 GMT) X-Complaints-To: usenet@news.cdn.telstra.com.au NNTP-Posting-Date: 10 Oct 2001 07:09:52 GMT X-Newsreader: MicroPlanet Gravity v2.30 Xref: easynews comp.databases.oracle.misc:70105 comp.databases.oracle.server:120764 comp.databases.oracle.tools:45365 comp.sys.hp.hpux:106546 comp.sys.hp.misc:21581 X-Received-Date: Wed, 10 Oct 2001 03:37:56 MST (news.easynews.com) 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 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.