Re: ORA-01654

From: Richard <qaz1521_at_hotmail.com>
Date: Mon, 8 Sep 2003 23:24:24 +0100
Message-ID: <bjivip$9qk$1$8300dec7@news.demon.co.uk>

You are correct Sybrand. Thanks for the correction. Compress extents will only reduce fragmentation of exported segments wont it? You would need to drop everything in the index tablespace then coalesce the free space before recreating the indexes to reduce free space fragmentation. I suppose you could also recreate the indexes in a fresh tablespace.

Does anybody know if there is an on line defragmentation tool available for Oracle, like the tools that are used to defragment disk drives without reformatting?

Richard

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:jaqplvga409tdk172537g106d3s4dk7bb0_at_4ax.com...
> On Mon, 8 Sep 2003 19:51:04 +0100, "Richard" <qaz1521_at_hotmail.com>
> wrote:
>
> >The problem can be resolved using the exp tool with the compress extents
> >option.
>
> Bogus.
>
> This will aggravate the problem. Compress extents will create all
> current segments in one single extent and set next extent to 10
> percent of the initial extent. If you had equally sized extents, due
> to 'compress extents' they are all gone. The resulting free space will
> be fragmented more than before.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Mon Sep 08 2003 - 17:24:24 CDT