Re: maximum initial extent size

Actuly,

Solaris 2.6 has a maximum filesize limitation of 2GB ( 32 bit ).This means, U cant create a datafile more than 2GB.Since extents can't span across multiple datafiles, the maximum extent size becomes 2GB.Thats it!.this is only a OS limitation

Mohamed
DBA "David F. Newman" wrote:

> I tried to create a table with an initial extent of 3 Gigs (3072M)
> but I received this error:
>
> ORA-02218: invalid INITIAL storage option value
>
> After some experimenting with the initial parameter I found
> that I can't create a table with an initial extent larger than
> 2047M. The tablespace is one contiguous file 4096Megs long.
> I got around this by setting next to 1024M and minextents to 2.
> Is this a bug or is this a real limit. I am using Oracle 8.0.6
> on Solaris 2.6 with an 8k block size. Thanks.
>
> --
> David F. Newman
> Oracle DBA
> buzzwang_at_ourvillage.com
Received on Wed Jan 26 2000 - 16:53:00 CST