Re: Initial and next segment sizes in Oracle7.3

        Either way will work, but you really should go with uniform sizing and PCTINCREASE 0 in order to avoid having to defragment your database in the future.

        I inherited a system without uniform sizing and even though I have 400MB of free space there isn't a 22MB contiguous space that will allow the index on my largest table to extend. This coming week I will be writing scripts to move tables and indexes to uniformly sized tablespaces and next Saturday I will moving the whole database.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/6/00, 1:42:09 PM, "Ravi Polavarapu" <ravipolavarapo_at_mn.mediaone.net> wrote regarding Initial and next segment sizes in Oracle7.3:

> Does it make a difference to have a big initial segment and smaller
 next
> segments while creating a table
> to multiple segments (intial and segments) of the same size ?
> Does oracle7.3 has the ability to work the same way in either case ?
 

> Thanks for the input
> Ravi
Received on Sun May 07 2000 - 00:00:00 CDT