Re: Index organized partitioned table can't be rebuilt

From: Karsten Schmidt <groups_at_karsten-schmidt.com>
Date: 16 Jul 2003 00:20:27 -0700
Message-ID: <c6711ac4.0307152320.353c01a3@posting.google.com>

Hi,
 two options (I am writing this out of my head, various syntax thingies are missing ...)

1. CREATE TABLE NEW_IOT AS SELECT * FROM BIG_IOT PARTITION (P1) ... ALTER TABLE BIG_IOT EXCHANGE PARTITION P1 WITH TABLE NEW_IOT
2. ALTER TABLE BIG_IOT MOVE PARTITION P1 ...

 make sure, this really is an 'old' partition with (virtually) no new inserts, otherwise the effort would be futile, and you would be doing more harm than good.

Regards
 Karsten

andkovacs_at_yahoo.com (Andras Kovacs) wrote in message news:<412ebb69.0307151330.122db737_at_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 Wed Jul 16 2003 - 02:20:27 CDT