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: MAXSIZE 32767M

Re: MAXSIZE 32767M

From: Lou Fangxin <anysql_at_gmail.com>
Date: Tue, 8 Aug 2006 23:19:12 +0800
Message-ID: <ea5907d30608080819o145971acs8dd68ad184528d0e@mail.gmail.com>


It's should be 2^22-1 blocks * db_block_size for single for tablespace under 10g or SMALLFILE on 10g, for BIGFILE tablespace in 10g, one fileonly per tablespace, then the maxsize is 2^32-1 blocks.

On 8/4/06, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> tragically, I was responding from a mobile phone and so didn't have a
> calculator when composing the mail. its 2^32 -1 blocks * blocksize which as
> sergey states is 32gb for 8k blocks, would be 64gb for 16k blocks.
>
> I'll get my coat.
>
>
> On 8/3/06, Sergey Popov <sspopov_at_gmail.com> wrote:
> >
> > 32Gb is the maximum for 8K blocks.
> >
> >
> > On 8/3/06, Niall Litchfield <niall.litchfield_at_gmail.com > wrote:
> > >
> > > dba_data_files. you have specified unlimited for max size when
> > > creating the datafile. unlimited means the maximum no of blocks
> > > multiplied by the block size of the ts. so you have a smallfile ts
> > > with iirc a 16k blocksize.
> > >
> > >
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

-- 
Welcome!
Home: http://www.IamDBA.com

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 08 2006 - 10:19:12 CDT

Original text of this message

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