Re: ORA-01654

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 08 Sep 2003 22:42:55 +0200
Message-ID: <jaqplvga409tdk172537g106d3s4dk7bb0@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 - 15:42:55 CDT