Database DataWarehousing (MOSC)

MOSC Banner

Some indexes or index [sub]partitions of table have been marked unusable

edited Oct 10, 2014 10:27AM in Database DataWarehousing (MOSC) 2 commentsAnswered

Alert log for 11.2.0.3 database contained above mentioned error. As per 11g documentation, value for STATUS column in <ALL>_IND_PARTITIONS should be either USABLE or UNUSABLE where as status of index partition of related table is "N/A".

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