Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reduce or shrink the physical size of a text index
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
Received on Fri Sep 02 2005 - 01:02:55 CDT