Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 2GB or not 2GB (datafile limit)? That is the question.

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

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Sat, 9 Sep 2006 10:27:07 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5AFA7@ex2.ms.polyserve.com> 




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


Received on Sat Sep 09 2006 - 12:27:07 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US