Re: Index organized partitioned table can't be rebuilt

Andras Kovacs wrote:

> 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.

Please explain what you mean by "Recently we had a lot of inserts into one of the partitions and the
index is unbalanced."

What is the specific problem? And why are you trying to do something about it?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)