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!

ORA-01502: index partition of such index is in unusable state

731197May 5 2010 — edited May 5 2010
one of my index is in unsusable state. Can I rebuild the index online using
select 'alter index '||owner||'.'||index_name||' rebuild;' from
dba_indexes where STATUS = 'UNUSABLE';

will it be any impact as this, its a production db and user is complaining they are not able to run the query.


Oracle: 10.2.0.4.0
OS: RHEL
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2010
Added on May 5 2010
#general-database-discussions
1 comment
843 views