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

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 8 Sep 2006 09:24:39 -0700

>>>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 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.


Other related posts: