Re: Why do objects become invalid?

>Hello,
>I want to ask a question,
>When I connect as system/mamanger and
>SELECT * FROM ALL_OBJECTS WHERE STATUS = 'INVALID';
>I can find some objetcs like procedures,triggers,views become INVALID.
>And if I recompile the scripts,the objects' STATUS become VALID.
>But I don't know why?
>'Cause I don't alter the objects,but they become INVALID.
>Please give me more information about this.
>Please Cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :-)
>
>

If any of the objects referenced are altered, then the object is marked as invalid. Depending on what it is, different things can cause an object to be invalid. For example...

view - drop a table, create/drop an index, add a colum to a table used in the query

packages - same as view for any tables/views involved. If you reference another package, if the referenced package has its package spec ( not just the body) recompiled, the one referencing it is marked as invalid.

Dan Hekimian-Williams Received on Tue Sep 15 1998 - 21:52:26 CDT