Skip to Main Content

SQL & PL/SQL

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!

ORA-01502: The index 'WKSP_LESPIEDSBOTS.UK_INSC_COMP_PART' or its partition is unusable

Christian Pitet.Jun 11 2026

Hi Under Oracle 19c, I try to delete a record from the table Competions. There are records form the table Matchs who has columns containg the primary key of the table Competitions. When I try to delete a record from the table Competions (I delete at the same time the records of the table Matchs that contains record with the primary key of Competitions, I get this error message:

ORA-01502: The index 'WKSP_LESPIEDSBOTS.UK_INSC_COMP_PART' or its partition is unusable

Best regards.

This post has been answered by Gerrit van der Linden on Jun 11 2026
Jump to Answer
Comments
Post Details
Added on Jun 11 2026
2 comments
343 views