Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reduce or shrink the physical size of a text index

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

From: www.twisted-nail.com <primoz.mihelic_at_email.si>
Date: 1 Sep 2005 23:02:55 -0700
Message-ID: <1125640975.073108.302220@f14g2000cwb.googlegroups.com> 






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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US