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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

drop a partitioned index

User_KWXZ9Mar 3 2014 — edited Mar 3 2014

Hi Friends ,

I am using 10.2.0.4 oracle on solaris .

i have multiple partitioned local indexes from 2011 created on a daily basis . I tried to drop one of the indexes and got the below error .

SQL> ALTER INDEX QOSDEV.PK_RATE_CISCOMEMORYPOOL DROP PARTITION "05OCT2012"

ALTER INDEX QOSDEV.PK_RATE_CISMEPOOL DROP PARTITION "05OCT2012"

Error at line 2

ORA-14076: submitted alter index partition/subpartition operation is not valid for local partitioned index

Script Terminated on line 2.

I kindly request the way to drop these partitions .

Thanks ,

DBApps
This post has been answered by Anand... on Mar 3 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 31 2014
Added on Mar 3 2014
#general-database-discussions, #index
8 comments
1,347 views