Re: SMON and coalescing

From: Peter Broadfield <GBH3R4BR_at_IBMMAIL.COM>
Date: Tue, 2 Jun 1998 18:32:26 +0100
Message-ID: <6l1asi$dmg1@extnews.sunalliance.com>

Mark,
Sorry but the answer is No.
Coalescing will only join together to adjacent chunks of 'free space' to make one bigger chunk of 'free space'. The tables themselves will not be affected so you will still have to defragment them. --
Regards Pete
Mark Gornicki wrote in message <3570D006.6EC1_at_netcomuk.co.uk>...
>hi
>
>excuse my ignorance but is 'coalescing' defragmenting the tablespace,
>thus no longer requiring export/import?
>
>thanks,
>Mark
>
Received on Tue Jun 02 1998 - 12:32:26 CDT