Re: Fragmented tablespace

I'd be surprised. De-fragmentation is the act of unloading the blocks and then reloading them in larger contiguous extents. You must drop the object to reload it.

As for tools. I'm working on a db at the moment which is 162GB and grows at a rate
of 1gb per week. For reorgs we have a tool frrom platinum called TSREORG.

This has a fast unload option and since we use it on an 8 way Unix server we unload and reload using 6 threads. The last big reorg I did was 29gb of data tablespace and it managed it in just under 9hrs. That includes all the index rebuilds.

honestly, I DONT work for platinum, but it's a damn good product.

Des Collins wrote in message <36E53576.34E8_at_bt.removeme.com>...
>Dear All,
>
>Is there a way of de-fragmenting a large tablespace (+2g) without
>re-creating it. Are there any tools out there that lets you do this.
>
>Any help / suggestions appreciated
>
>Thanks
>--
>Des Collins
>UK
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> These are my views and NOT those of my empoyer.
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Received on Tue Mar 09 1999 - 09:55:25 CST