RE: 2GB or not 2GB (datafile limit)? That is the question.

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Fri, 8 Sep 2006 09:24:39 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AF8B@ex2.ms.polyserve.com>

>>>

>>>Rich, I think the answer depends on your OS. If the OS is
>>>configured to handle datafiles of 32G or larger then leave
>>>the setting alone. If your OS have a 4G file limit then

...is there still a filesystem where Oracle is supported that limits file sizes to 4GB? That would seem weird.

Of course a file can only have (2^21)-1 database blocks unless it is a 10g BIGFILE tablespace so you can't get all that huge anyway with 2 or 4KB oracle blocks.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 08 2006 - 11:24:39 CDT