Skip to Main Content

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 'indexname' or partition of such index is

ParitoshSharmaMay 6 2010 — edited May 6 2010
Hi All,

I am facing an error while preforming Merge on a table.

Error is :- ORA-01502: index 'Index_name' or partition of such index is in unusable state.

please suggest how to get rid of it....

thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2010
Added on May 6 2010
5 comments
882 views