Re: partitioned index problem

From: stephen O'D <stephen.odonnell_at_gmail.com>
Date: Thu, 5 Jun 2008 09:14:51 -0700 (PDT)
Message-ID: <065287f1-5b1a-4d08-b421-0a8c5baa3cd9@i76g2000hsf.googlegroups.com>


On Jun 5, 9:02 am, walrus <jacek...._at_avantis.pl> wrote:
> hi,
>
> I've got composite range partitioned index and I want to move it to
> another tablespace.
>
> From dba_ind_partitions - partition X is in tablespace_A
> From dba_ind_subpartitions - subpartitions of partition X are in
> tablespace_B
>
> How to mave partition X to tablesapce_B?
>
> I can't rebuild whole partition because I would get ora-14287
> When I have rebuilt subpartitions - it was succesful, but nothing has
> changed.
> I have also tried to modify default attributes of this index but it
> didn't helps too.
> WHY ? :)
>
> thanks
>
> oracle 10.2.0.3, entp edition, unix

From reading what ORA-14287 means, I guess Oracle has just decided its not allowed (probably some complex internal reasons?)

ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index
Cause: User attempted to rebuild a partition of a Composite Range partitioned index which is illegal
Action: REBUILD the index partition, a subpartition at a time Received on Thu Jun 05 2008 - 11:14:51 CDT

Original text of this message