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)  :-)
--
http://www.freelists.org/webpage/oracle-l


Other related posts: