Oracle Database Discussions

Hello all,

I recently assumed responsibility to support a OLTP production databases and found out there are many indexes in 'N/A' status under primary schema. A retek table item_loc has its primary index key in 'N/A' status. My understanding is queries that access that table will not use that pk because of its 'Not Available' status plus all ref integrity constraints also fail.

Please advise if my understanding is correct and how do I resolve this problem.

Thanks in advance.

leim