Although Oracle 7.1 and 7.2 do not have the COALESCE clause of the ALTER
TABLESPACE command, some coalescing of neighboring free extents will be
done by the SMON process if you have the proper tablespace settings in
effect. Particularly, your PCTINCREASE value at the tablespace level must
be non-zero. I use a 1percent PCTINCREASE value for my tablespaces and
specify zero percent PCTINCREASE for segments within the tablespace. This
allows for coalescing by SMON without the geometrical growth of extents
caused by non-zero PCTINCREASE values for segments.
--
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
-------------------------------------------------------------------------
(Due to proliferation of spammers, remove nospam from address.)
Fuzzy <granta_at_nospam.student.canberra.edu.au> wrote in article
<344e96d4.4582877_at_newshost.interact.net.au>...
> Hi people,
>
> 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?
>
> Ciao
> Fuzzy
> :-)
>
>
Received on Thu Oct 23 1997 - 00:00:00 CDT
