Re: partitioned index problem

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 05 Jun 2008 09:51:32 -0700
Message-ID: <1212684689.433426@bubbleator.drizzle.com>


walrus 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

If you have composite partitioning the indexes are at the subpartition level: There are no partition level indexes.

Post your DDL. I can not guess accurately at what command you are using.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Jun 05 2008 - 11:51:32 CDT

Original text of this message