Re: Why do objects become invalid?

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Tue, 15 Sep 1998 19:27:00 -0700
Message-ID: <6tn7cq$65f@sjx-ixn4.ix.netcom.com>

IF you make changes to the objects which those "invalid" objects depends on, such as changes on table. The objects will then became invalid. But the next time you call those objects again, (if everything is valid), Oracle will recompile that for you again.

Winnie

Violin wrote in message <360a1c6d.7714776_at_news.twsc.pouchen.com.tw>...
>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 :-)
Received on Tue Sep 15 1998 - 21:27:00 CDT