Re: ORA-28660 : IOT's partition can't be moved online

Have you tried moving just the specific partition? The syntax should be something like the following:

ALTER TABLE my_table MOVE PARTITION the_partition TABLESPACE new_ts;

HTH,
Brian

Andras Kovacs wrote:
>
> Hi,
>
> We are using oracle 9.2.0.1.
> We have an index organized partitioned table.
> We had a lot of inserts into one of the partitions and the index is unbalanced.
> I want to reorganize the table but the move online clause doesn't work.
>
> SQL> alter table history move online;
> alter table history move online
> *
> ERROR at line 1:
> ORA-28660: Partitioned Index-Organized table may not be MOVEd as a whole
>
> This error is normal.
>
> However I can't find the syntax to move online just one partition.
> Is it possible in oracle 9 ?
> What would be the syntax ?
>
> Thanks.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"