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: Index organized partitioned table can't be rebuilt

Re: Index organized partitioned table can't be rebuilt

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 15 Jul 2003 14:30:25 -0700
Message-ID: <412ebb69.0307151330.122db737@posting.google.com> 





Inserts mean: new data set in the historical data.



When I think that the index is unbalanced it means that the
performance is not as good as before and the index uses much more
space. If I drop and rebuild the same index after the inserts the
space usage drops by 20-25%.



But I don't want to drop a 100GB table everyday ....



Is there an option to rebuild an index organized partitioned table
online in Oracle 9 ?




Is there an expert out there ?
Received on Tue Jul 15 2003 - 16:30:25 CDT












Original text of this message













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