Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-28660 : IOT's partition can't be moved online

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

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Mon, 14 Jul 2003 18:16:22 GMT
Message-ID: <3F12F376.8C3674E0@remove_spam.peasland.com>


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"
Received on Mon Jul 14 2003 - 13:16:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US