Identifying and Fixing Invalid and Unusable Objects

First, the terminology. Ideally, all objects have a status of valid. PL/SQL objects and views can become invalid; indexes can become unusable. Depending on the reason for an object becoming invalid, it may become valid automatically when next accessed. Unusable indexes must be made valid by rebuilding, which does not occur automatically.