Re: Initial extent of table

From: <patilv_at_sharpsec.com>
Date: 1998/06/01
Message-ID: <6kv9e2$7dv$1@nnrp1.dejanews.com>#1/1

In article <3572A04E.34EF_at_nortel.ca>,
Peter Chan <chanp_at_nortel.ca> wrote:
>
> Is there a maximum on the initial extent size of a table?
>
> Is it a good idea to make an initial extent of a table to be larger than
> the size of a datafile in a tablespace?
>
> Thanks a bunch!
> --
> ====================================================================
> PETER CHAN, Northern Telecom
> PHONE: (613) 763-9096 FAX: (613) 763-4408 EMAIL: chanp_at_nortel.ca
> ====================================================================
>

The maximum on the intial extent is the size of the tablespace(less some space taken for indexes, overheads etc) only if that is the only table in that tablespace.

You cannot have the intial extent more then the space in the tablespace because Oracle will try to allocate the extent when the table is created and will fail due to insufficient space.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 01 1998 - 00:00:00 CDT