check kernel params. also try to create a large file not using oracle, see if it fails. i have seen i/o errors w/ autoextend on, just a thought.
>>> treegarden_at_yahoo.com 04/04/02 06:57PM >>>
Large file support is the first thing I checked (I should have put that
in my post). It's enabled on all volumes.
- Gene Sais <Gsais_at_co.palm-beach.fl.us> wrote:
> 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).
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 Fri Apr 05 2002 - 07:23:41 CST
