Database Administration (MOSC)

MOSC Banner

'N/A' indexes

edited Nov 17, 2009 9:41AM in Database Administration (MOSC) 3 commentsAnswered
 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.

milic

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center