Re: ORA-27072/HP-UX file too large

From: Gene Sais <Gsais_at_co.palm-beach.fl.us>
Date: Thu, 04 Apr 2002 09:04:59 -0800
Message-ID: <F001.0043B7B1.20020404090459@fatcity.com>

its an os problem, make sure your filesystems are large enabled. aix has a 64gb filesize limit, forgot what hp ux is.

>>> treegarden_at_yahoo.com 04/04/02 11:23AM >>>
Hi, all.

Oracle 8.1.7.2.0 on HP-UX B.11.00.

When performing a full database export, I'm getting

EXP-00008: ORACLE error 1114 encountered
ORA-01114: IO error writing block to file 201 (block # 366985)
ORA-27072: skgfdisp: I/O error

HP-UX Error: 27: File too large
Additional information: 366985
ORA-01114: IO error writing block to file 201 (block # 366985) ORA-27072: skgfdisp: I/O error
HP-UX Error: 27: File too large
Additional information: 366985
EXP-00000: Export terminated unsuccessfully

File 201 is a tempfile, for the temporary tablespace. Its size is approx. 3 GB. A similar full export runs nightly and succeeded last night (I can't be sure about all previous nights as they don't save the log files).

Has anyone else seen this? Why is export writing to the temporary tablespace?

TIA

---

Paul Baumgartel, Adept Computer Associates, Inc. paul.baumgartel_at_aya.yale.edu

---

Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Paul Baumgartel
  INET: treegarden_at_yahoo.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Apr 04 2002 - 11:04:59 CST