Alter Table - Invalid Object

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 26 Feb 2008 11:58:13 -0800 (PST)
Message-ID: <79132.87351.qm@web51302.mail.re2.yahoo.com>

Hi

I want to understand that if I alter some table which has lots of other dependent objects like Package,procedure,view etc. These dependent object will be invalid. Do I need to compile them or some of them will be compiled automatically when they are executed again by the application. Any Reference to check as what will be invalidated and at which condition like when the actual column been used in the db objects are modified or even table is subjected to DDL.

TIA
Sanjay

---

Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 26 2008 - 13:58:13 CST