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: Sergey Popov <sspopov_at_gmail.com>
Date: Thu, 3 Aug 2006 15:10:33 -0400
Message-ID: <d9f8ed890608031210r4aef924ajed68eb288d282d96@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 03 2006 - 14:10:33 CDT

Original text of this message

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