2 Replies Latest reply: Apr 1, 2009 1:52 AM by 678145 RSS

    Why we have indexes with STATUS = N/A.

      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