Alter Table - Invalid Object

From: Sanjay Mishra <>
Date: Tue, 26 Feb 2008 11:58:13 -0800 (PST)
Message-ID: <>


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.


Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Received on Tue Feb 26 2008 - 13:58:13 CST

Original text of this message