RE: 2GB or not 2GB (datafile limit)? That is the question.
- From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
- To: <dbvision@xxxxxxxxxxxx>
- Date: Sat, 9 Sep 2006 10:27:07 -0700
>>>See here:
>>>http://download-west.oracle.com/docs/cd/B10501_01/server.920/
>>>a96536/ch43.htm#287916
>>>
>>>The limit is 2^22 -1 , not 2^21 - 1.
>>>The reason I say "around" is that I'm not game to argue the
aaaaaaaaaaaargh, yes, of course, so sorry. a dba is 10bits for which
file and 22 (-1) for block offset. Dang the memory!
Sorry for the snafu...and yes, 30GB is
almost 31.99999237060546875GB ((((2^22)-1)*8KB)/1GB) :-)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
