Re: how to reduce file size to minimum?

Hi,
Geoff Reader <grr_at_NOSPAM.bton.ac.uk> wrote in message news:<3B692FE2.A4F4684_at_NOSPAM.bton.ac.uk>...
> I thought alter tablespace coalesce merged adjacent free blocks into contiguous
> space, used for example for tables where pctincrease = 0 and this is not done
> automatically. rather than creating free space out of partially used blocks.

right

>
> I don't see at all how it can be used to defragment your datafiles, but then I
> am still using primarily 7.3.4. Change will come.
>
> I'd be interested to know if this does work in 8+

NO

>
> Geoff
> Geoff Reader
> Analyst Programmer
> University of Brighton

Thomas Received on Fri Aug 03 2001 - 03:44:00 CDT