Hi,
My guess is that the file system you are writing to doesn't handle large files. (>
2 GB)
Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, April 04, 2002 10:24 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-27072/HP-UX file too large
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.
[EMAIL PROTECTED]
__________________________________________________
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Carle, William T (Bill), ALINF
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
