Re: MAXSIZE 32767M

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

--
http://www.freelists.org/webpage/oracle-l