Skip to Main Content
Forums

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!

EXCEPTION: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

659140Jun 3 2009 — edited Jun 3 2009
Hello,

I'm getting the exception when I go to run the following update statement (via PreparedStatement using JDBC):

UPDATE my_table SET my_column_1 = ? WHERE my_column_ID = ?

I searched google and couldn't determine the proper fix for this:

http://ora-29861.ora-code.com/

What I do know from SQL Developer:

my_table has several indexes of which all have a status of "valid"
my_column_ID has an index on it. the column type for this column is NUMBER(10,0)
my_column_1 is a VARCHAR2(40 BYTE)

So I'm uncertain where to go from here and any help would be great.

Thanks,
Jim

Edited by: Jim Atharris on Jun 3, 2009 4:54 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2009
Added on Jun 3 2009
1 comment
1,847 views