Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR at line 1: ORA-28650: Primary index on an IOT cannot be rebuilt

877826Mar 8 2013 — edited Mar 9 2013
Hi All,

When i was trying to move index partitions from one tablespace to another tablespace i am getting below Error.
ERROR at line 1: ORA-28650: Primary index on an IOT cannot be rebuilt

Query :
alter index Test_PK3 rebuild partition P_20111212 tablespace TAB_SP

Note Test_pk3 is an index on IOT table.

Can any one Suggest me to resolve this problem.


Thanks
Sree
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2013
Added on Mar 8 2013
#general-database-discussions
5 comments
12,772 views