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 on drop partition

877379Jul 25 2011
Hello,

When i execute this command i get this:

SQL> ALTER TABLE RMPM.GROUPE_AFFAIRES DROP PARTITION PART_71;
ALTER TABLE RMPM.GROUPE_AFFAIRES DROP PARTITION PART_71
*
ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of RMPM.IDX_GA_LIB
ORA-29881: failed to validate indextype


I d'ont know why???

Thanks
PS: oracle version is 9.2.0.6.0 on AIX
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 22 2011
Added on Jul 25 2011
#general-database-discussions
0 comments
124 views