Re: Extents

From: <sigdock_at_my-deja.com>
Date: 2000/07/18
Message-ID: <8l14rv$9ki$1@nnrp1.deja.com>#1/1

If you want to reorganize only an index how about dropping it and create it with new sizing parameters for the initial extent? You can also use the REBUILD-option.

BertJan Meinders
Oracle DBA
ASR-ICT In article <0218fd46.3eb16e2d_at_usw-ex0105-037.remarq.com>, Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid> wrote:
> Platinum puts out a product called TS-REORG which I have not
> checked out but I think it does this. Also there has been a lot
> of talk on the boards here about switching to "Locally Managed
> Tablespaces", I'm still looking into both of these options. The
> latter I think is a new feature in 8i.
>
> -Ethan
> http://www.freetechnicaltraining.com/oracle_links.htm
> http://www.gnumetrics.com
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 18 2000 - 00:00:00 CDT