Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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