maximum initial extent size

From: David F. Newman <buzzwang_at_localhost.localdomain>
Date: Wed, 26 Jan 2000 22:27:07 GMT
Message-ID: <86n1pssbz6.fsf@localhost.localdomain>

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:27:07 CST