ORA-28660: Index organized partitioned table

From: Andras Kovacs <andkovacs_at_yahoo.com>
Date: 14 Jul 2003 10:46:57 -0700
Message-ID: <412ebb69.0307140458.5a498197@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 - 12:46:57 CDT