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!

ORA-01502: index '<index_name>' or partition of such index is in unusable state

Madhu_KJul 28 2016 — edited Sep 14 2016

Hello All,

Oracle database 11g EE 11.2.0.4

As we know, when we set SKIP_UNUSABLE_INDEXES=TRUE, Oracle should not report ORA-1502 error for a non-unique index.

Does this mean, Optimizer wont use unusable non-unique index during query execution? or Is the Optimizer free to choose an unusable non-unique index in case, if you have used an index hint in the query to force index scan.

If the optimizer uses an unusable non-unique index during query execution, is it a normal behavior to throw ORA-1502 error?

Thanks,

Madhu
This post has been answered by Madhu_K on Sep 14 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2016
Added on Jul 28 2016
27 comments
1,545 views