Re: maximum initial extent size

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 26 Jan 2000 22:40:48 +0800
Message-ID: <388F0770.1DA3@yahoo.com>

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

Several limits within Oracle are 2G.

Also in some versions of Solaris only support asynch io up to 2G and not beyond - you may want to check this for 2.6

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jan 26 2000 - 08:40:48 CST