Re: Help coalescing free space

COALESCE will only coalesce ADJACENT free extents and not bits of free space all over the tablespace. Unless Oracle can find the 250mb contiguous free space you need you won't be able to create the table with that storage parameter.

Mike heydon <pgbison_at_iafrica.com> wrote in article <01bce2d1$40a30900$29af0bc4_at_mheydon>...
> ,
> > >
> > > Once again I'm suffering from the joy of Oracle's space management
> > > techniques (or lack thereof). I've got a 7.1 database, with 700 Mb
> > > free, but cannot create a table with initial of 250M and next 100M
> > > because the freespace is fragmented. Is there a coalesce free space
> > > option in 7.1?
>
>
> In 7,1 and 7.2 SMON will coalesce space automatically if the PCT INCREASE
> for the storage Parameters
> of the TABLESPACE is NON ZERO.
>
> In 7.3 there is a command "ALTER TABLESPACE <Tablespace> COALESCE" which
> can be used regardless of
> the PCT INCREASE setting.
>
> Regards,
> Mike Heydon
>
>
Received on Wed Oct 29 1997 - 00:00:00 CST