Re: Max Extents reached !!

From: mj <mjevans_at_nospam.bigfoot.com>
Date: Fri, 12 Mar 1999 22:54:12 -0500
Message-ID: <36E9E164.172AFB51@nospam.bigfoot.com>

John0725 wrote:
>
> If possible, you really should rebuild your table so that all of the data can
> fit into one extent. You can do so with the exp and imp utilites using the
> parameter COMPRESS = Y.

Hey.....READ the question. The writer is talking about the TEMP tablespace. No tables involved.
The answer is to re-create the TEMP tablespace with larger, equal initial and next extent sizes.

By the way, if the above is the way you reorg your tables, you are letting Oracle's dynamic extent allocation algorithm have its way and will soon end up with "swiss cheese" tablespace fragmentation that will have you doing reorgs every weekend. ALWAYS specify table/index initial/next extent sizes in exact multiples of 5 data blocks and always specify storage parameters for every table/index and you won't have to reorg for a very long time. Received on Fri Mar 12 1999 - 21:54:12 CST