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....htm#CCREF0101
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)