Re: Reduce or shrink the physical size of a text index

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Sep 2005 09:38:56 -0700
Message-ID: <1125679088.343229@yasure>

www.twisted-nail.com wrote:
> Snewber je napisal:
>

>>For some reason a few of our text indexes have blown out to about 3Gb.
>>I'm still investigating why. Is it possible to reduce the physical size
>>of the index while keeping it online? Is it even possible to reduce it's
>>physical size without dropping it?

>
>
> Hi Snewber,
>
> You can rebuild indexes online. Syntax:
> alter index INDEX_NAME rebuild online.
>
> Best regards,
> Primoz
> www.twisted-nail.com

Addendum: For domain indexes you can only rebuild them if they are not marked IN_PROGRESS.

also:
http://download-west.oracle.com/docs/cd/B19306_01/text.102/b14218/csql.htm#CCREF0101

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Fri Sep 02 2005 - 11:38:56 CDT