Re: Empty fragments in tablespaces

There are ALTER TABLESPACE <tablespace_name> COALESCE; in Oracle 7.

Jurij

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 Fri Jun 12 1998 - 07:51:44 CDT