Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Empty fragments in tablespaces
In Oracle7, you can combine adjacent free extents in a tablespace by
coalescing the tablespace. This will be periodically done automatically
by SMON if the tablespace has a pctincrease > 0. This can also be done
manually in 7.3+ with the Alter Tablespace ..... Coalesce command.
Didier wrote:
> With ORACLE 6, when you create a table and after you drop il, you
> still have an empty extent that fragments the tablespace. And in time,
> the tablespace can be empty but you can't allocate a huge initial
> extent table.
> I would like to know from which ORACLE 7 release it is fixed (7.2, 7.3
> or more), and if there is solution to force the unfragmentation in
> previous release.
> Than you very much.
Received on Thu Jun 11 1998 - 20:22:35 CDT