Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

partitioned index problem

14 views
Skip to first unread message

walrus

unread,
Jun 5, 2008, 4:02:44 AM6/5/08
to
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

stephen O'D

unread,
Jun 5, 2008, 12:14:51 PM6/5/08
to

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

DA Morgan

unread,
Jun 5, 2008, 12:51:32 PM6/5/08
to

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
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

0 new messages