Oracle Database Discussions

Oracle Version : 10.2.0.3.0

Hi,

I have a subpartitioned index -> partitioned by range and subpartitioned by list. I have to move this index to another tablespace. I have successfully moved all the subpartitions but indexes's views always show me references to the old tablespace.

I have moved all the subpartitions as follow :ALTER INDEX MYINDEX REBUILD SUBPARTITION MYSUBPARTITION TABLESPACE NEWTABLESPACE ;
Now when i look the corresponding index segments with "dba_segments" view, they are moved correctly to the new tablespace.

But,

in the column "def_tablespace_name" of "dba_part_indexes" view the value is still the old tablespace name.
in the column "tablespace_name" of "dba_ind_partitions" view the value is still the old tablespace name.

in the column "tablespace_name" of "dba_ind_subpartitions" view the value is correct, referencing the new tablespace.

What do i have to achieve to have these values properly set (in dba_part_indexes and dba_ind_partitions)?

I have tried
alter index myindex rebuild partition mypartition tablespace newtablespace;
but i have the error :

Error: ORA-14287
Text: 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

Thank's



Kind regard's

Stéphane

Edited by: user9928511 on 13 mars 2009 11:29