Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Datafile size in Windows NTFS

Re: Oracle Datafile size in Windows NTFS

From: Adrian Carlson-Hedges <adrian.ch_at_btinternet.com>
Date: Tue, 3 Dec 2002 08:22:23 +0000 (UTC)
Message-ID: <DGsBZYCNiG79Ew1l@btinternet.com>


In message <asf9l5$o71$1_at_news.telbank.pl>, Yareck <jpalka_at_interia.KILLSPAM.pl> writes
>Użytkownik shafeek napisał:
>> Hi all
>> Is there any limitation of the size of the datafile for NTFS.
>> Thanks in advance.
>
>Windows2000Server + NTFS + Oracle 9i2, limitation is 4GB.
>
>Beyond this size Oracle reports an error in alert.log:
>ORA-01114: IO error writing block to file 201 (block # 524041)
>ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
>
>

Looks like a bug has been introduced. I inherited a database that quite happily had a 10Gb datafiles. NT4 +SP6a, NTFS, Oracle 8.1.6.

-- 
Adrian Carlson-Hedges
Received on Tue Dec 03 2002 - 02:22:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US