Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Datafile size in Windows NTFS
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-HedgesReceived on Tue Dec 03 2002 - 02:22:23 CST
![]() |
![]() |