Posted on 2004-11-26
To speed up input performance, I set a primary key index to unusable( and altered session to skip unusable indexes). When attempting to insert into the table, I received an error message of index 'index_name' or partition of such index is in unusable state. I think this is because there is a primary key constraint using this index that is still enabled. First question is "Is that the problem?" and the second question is "How do I disable the constraint?"