Why we have indexes with STATUS = N/A.
693933Apr 1 2009 — edited Apr 1 2009When 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