Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

FREE TRIALS

Notice: ORA-01502: index 'xxx.xxx_x' or partition of such index is in unusable state. (4250230)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Notice: ORA-01502: index 'xxx.xxx_x' or partition of such index is in unusable state.
Description

event_log shows the following error:

Notice: ORA-01502: index 'xxx.xxx_x' or partition of such index is in unusable state.
Cause

index specified in the above error message became corrupt
Resolution

1. Stop the related Shareplex process
2. DROP the specified index and REBUILD the specified index, or REBUILD the unusable index partition
3. restart the Shareplex process

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Leave a Comment

Recommended Content

Product(s):: SharePlex
5.3

Topic(s):: Technical Solutions

Article History:: Created on: 1/12/2000
Last Update on: 5/7/2023

Search All Articles