Re: INVALID objects - which objects?

Martijn Tonies wrote:

> Hello,
>
> Can ANY object in Oracle have the status "invalid"?
>
> Or is this only applicable to source code objects (Stored
> Procedures, Packages, Types etc...)

Indexes can be invalid. Especially common with indexes on partitioned tables when partitions are dropped.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)