Re: Does 7.3.3 command COALESCE tablespace work ?

From: Alan Campbell <ajc_at_cgocable.net>
Date: 1998/03/04
Message-ID: <34FDFD65.C1F53123@cgocable.net>#1/1

The tablespace coalesce only consolidates contiguous free extents. It does not perform any other defragmentation tasks. The only way to defragment is to recreate/rebuild the objects using whatever method you prefer.

news.neighbornet.net wrote:

> I have tried to use -- alter tablespace the_tablespace_name coalesce --
> to defragment a tablespace. Then I looked at the table dba_free_space to
> see if the free space has been made contiguous. I did not see any
> improvement. Has anyone tried it ? Does it work ?
>
> Thanks
Received on Wed Mar 04 1998 - 00:00:00 CST