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: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

WhayneOct 2 2013 — edited Oct 3 2013

I have identify the index that is causing this problem by using this script:

SELECT index_name, status FROM sys.user_indexes WHERE status != 'VALID';

The status of the index is "INPROGRS"

After google-ing around, the only way forward is to drop this index and recreate it. (Do correct me if I am wrong)

Question:

If I am to drop this index and recreate it, will it have any impact to the table using this index?

Regards

Whayne
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2013
Added on Oct 2 2013
#general-database-discussions
5 comments
3,353 views