Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: MAXSIZE 32767M
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-lReceived on Tue Aug 08 2006 - 10:19:12 CDT