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!

Why we have indexes with STATUS = N/A.

693933Apr 1 2009 — edited Apr 1 2009
When I am trying to delete all the rows from a table i got this error
ORA-01502: index 'T.PK_T' or partition of such index is in unusable state

I checked the state of index using
select * from dba_indexes and it shows the status as N/A.

Now what i want to know, why an index comes to this state.
If any one has some idea, then please share

~Sammy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2009
Added on Apr 1 2009
#general-database-discussions
2 comments
17,892 views