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
...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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
