Index organized partitioned table can't be rebuilt

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 14 Jul 2003 09:32:52 -0700
Message-ID: <412ebb69.0307140832.5e773744@posting.google.com>

Hi,

We have an index organized partitioned table on Oracle 9.2.0.1 Recently we had a lot of inserts into one of the partitions and the index is unbalanced.
I want to rebuild (online) the partion or the entire table.

However I was unable to find the command (syntax). I have tried the following (and a lot of other things).

SQL> alter table sales_history move online; alter table sales_history move online

*
ERROR at line 1:
ORA-28660: Partitioned Index-Organized table may not be MOVEd as a whole

This error is normal.
Is it possible to rebuild this IOPT online in Oracle 9 ? What would be the syntax ?

Should an export/table solve the issue ? (The table is 100GB ....)

Thanks for your help. Received on Mon Jul 14 2003 - 11:32:52 CDT