Re: Help coalescing free space

From: Mike heydon <pgbison_at_iafrica.com>
Date: 1997/10/27
Message-ID: <01bce2d1$40a30900$29af0bc4@mheydon>#1/1

,
> >
> > 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 Mon Oct 27 1997 - 00:00:00 CST