When connecting to the database, the following error is displayed, indicating an index for the database is unusable:
-
ORA-01502: index 'XXXX_Data.PK_SCHEMAOBJDETAIL' or partition of such index is in unusable state
Solution
Perform the following procedure to make the index usable:
-
Run IIS reset on the selected site.
-
Log in to the site database and run the following SQL commands.
Each command should be executed one at a time, rather than in a batch.
select status from user_indexes where index_name ='PK_PUBOBJPRDETAIL'; (the status should be unusable)
alter table "PUBOBJPRDETAIL" drop constraint "PK_PUBOBJPRDETAIL";
drop index PK_PUBOBJPRDETAIL;
alter table "PUBOBJPRDETAIL" add constraint "PK_PUBOBJPRDETAIL" primary key ("OBJPROBID");
select status from user_indexes where index_name = 'PK_PUBOBJPRDETAIL'; (the status should be usable)