Re: initial extent

From: <michael_bialik_at_my-deja.com>
Date: 2000/03/30
Message-ID: <8c0gnm$p7n$1@nnrp1.deja.com>#1/1

Hi.

You cal use ALTER TABLE command to change NEXT extent value, but in order to increase the INITIAL extent you must either change your scripts or DROP and CREATE table again. You have to compute INITIAL extent size based on avg. row size, number of rows in table, db block size etc.
I usually define NEXT extent as 30%-40% of INITIAL.

HTH. Michael.

In article <38E3BA3F.7B813E84_at_auckland.ac.nz>, Bridget Reitsma <b.reitsma_at_auckland.ac.nz> wrote:
> Hi,
>
> I have some scripts that create tables for me - I know want to load
the
> tables with database but the initial extent are to small and I keep
> reaching the max extents also. How can i get by this? Should I change
> the initial and max extents in the sys.dba_tables table?
>
> cheers bridget
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 30 2000 - 00:00:00 CST